Skip to content

Registered aircraft · 17,028

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N7899NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0290 N7899UDeidiker Floyd D · West Plains, MOBuilt 1964 · S/N 17251899 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N78FGMcclanahan John B · Fayetteville, GAS/N 18255224 N79000Kemmis Sidney C · Prophetstown, ILBuilt 1968 · S/N 17257797 N79001Pau Hana Enterprises LLC Series IV · Boulder City, NVBuilt 1968 · S/N 17257798 N79002Fremont Aviation Inc · Fremont, NES/N 17257799 N79004Palmer Joe A · Meridian, IDBuilt 1968 · S/N 17257801 N79009Birkholz Raymond J · Boulder, COBuilt 1968 · S/N 17257806 N7900FValley Wine Exports LLC · Rollingbay, WABuilt 1966 · S/N 15064000 N7900GGreat Plains Enterprises LLC · Wilmington, OHBuilt 1970 · S/N 17259600 N7900NWarren County Sheriffs Dept · Mcminnville, TNBuilt 1968 · S/N R172-0291 N7900UJames Timothy C · Morehead, KYBuilt 1964 · S/N 17251900 N79012Brewer Jeremiah L · Eagle River, AKBuilt 1968 · S/N 17257809 N79013Woods Michael F · Hamilton, NJBuilt 1968 · S/N 17257810 N79014Fcs Aviation LLC · Lewisport, KYBuilt 1968 · S/N 17257811 N79015Flying Weaners Inc · Jacksonville, FLBuilt 1968 · S/N 17257812 N7901GRaines Adam D · Ridgewood, NJBuilt 1970 · S/N 17259601 N7901PTwo Brothers LLC · Helena, MTBuilt 1969 · S/N 18259640 N79021Smith Timothy C Trustee · Riverton, WYS/N 17257816 N79024Jwp Flying Services LLC · Chatfield, MNBuilt 1968 · S/N 17257819 N79027Arrow North LLC · Missoula, MTBuilt 1968 · S/N 17257822 N79028Jdc Aviation LLC · Upland, CABuilt 1968 · S/N 17257823 N7902NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0293 N79031Smith Robert L II · Spencer, WVBuilt 1968 · S/N 17257826 N79036Buiqui Aerospace Corp · Kissimmee, FLS/N 17257831 N7903FSmith Troy D · Arcadia, INBuilt 1966 · S/N 15064003 N7903GDunn Patrick J · Denver, COBuilt 1970 · S/N 17259603 N7903NUnited States Air Force · Usaf Academy, COBuilt 1968 · S/N R172-0294 N7903UCohen Bruce Robertson · Estes Park, COBuilt 1964 · S/N 17251903 N7903VQuintas Frank · Palm City, FLBuilt 1976 · S/N 177RG0914 N79040Higinbotham Larry L · Littleton, COBuilt 1968 · S/N 17257835 N79042N79042 LLC · Rock Hill, SCBuilt 1968 · S/N 17257837 N79048High Stakes Aviation LLC · Fresno, CABuilt 1968 · S/N 17257841 N7904GRight Rudder LLC · Rexburg, IDBuilt 1970 · S/N 17259604 N79050Batto Jeannie L · Madison, INBuilt 1969 · S/N 17257843 N79052Rose Gary A · Brighton, TNBuilt 1968 · S/N 17257844 N79054N18228 Inc · Williamsburg, VABuilt 1969 · S/N 17257846 N79055Amies John W · Zimmerman, MNBuilt 1968 · S/N 17257847 N79057First Eclipse Limited · Richmond, VABuilt 1968 · S/N 17257849 N7905NUnited States Air Force Owner · Peterson Afb, COBuilt 1968 · S/N R172-0296 N7905UAutrey Howard T · Freeport, TXBuilt 1964 · S/N 17251905 N79060K&L Aviation LLC · Prosper, TXBuilt 1968 · S/N 17257851 N79062Pierce Brenden D · Eatonville, WAS/N 17257853 N79063Sprague Todd K · Placerville, CABuilt 1968 · S/N 17257854 N79065Kingston Thomas P · Carmel, INBuilt 1968 · S/N 17257856 N79066Doran Vincent J Jr · Wasilla, AKBuilt 1968 · S/N 17257857 N79068Padgett Leonard Dale · Hobart, OKBuilt 1968 · S/N 17257858 N7906NHuppert Zachary D · Melbourne Beach, FLS/N R172-0297 N79071Cottrell Mark C · Leitchfield, KYBuilt 1968 · S/N 17257860

Back to AD 72-03-03 R3