Skip to content

Registered aircraft · 17,027

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.

N3562UPrairie Aviation Of Hamilton Inc · Corvallis, MTBuilt 1963 · S/N 18254962 N35632Briden Gordy D · Stacy, MNBuilt 1968 · S/N 17256876 N35638Newberry Ernest B Jr · Crawfordville, FLBuilt 1968 · S/N 17256879 N35639Sandwich Hawk LLC · Newark, ILS/N 17256880 N3563FParker Layne T · Gustavus, AKBuilt 1966 · S/N 18257563 N3563LMartinez Guillermo E · Upland, CABuilt 1965 · S/N 15062363 N3563UWest Robert M · Lake Oswego, ORBuilt 1963 · S/N 18254963 N3563YHegge Luke · Pine City, MNBuilt 1962 · S/N 18254463 N35644Pratt Sanders · Renton, WABuilt 1968 · S/N 17256882 N3564USkylane LLC · Luling, LABuilt 1963 · S/N 18254964 N35651Schubnell Ryan A · Avondale Estates, GAS/N 17256884 N35653Fitzgerald Bryan L · Craig, AKBuilt 1968 · S/N 17256886 N35656Hew Llp · Beresford, SDBuilt 1968 · S/N 17256888 N3565FKlosowski Mark Kevin · Lisbon, NYBuilt 1966 · S/N 18257565 N3565YRegistration Pending · Conrad, MTRegistration pendingS/N 18254465 N35662Warbington Michael L · Enid, OKS/N 17256890 N35665Imes Rusty J · Greenacres, WAS/N 17256893 N35667Gamby John E · Chadron, NEBuilt 1968 · S/N 17256895 N35668Schwartz Brenda A · San Angelo, TXBuilt 1968 · S/N 17256896 N35669Selkirk Seaplanes LLC · Hayden, IDBuilt 1968 · S/N 17256897 N3566YTocco Paul J · Crescent City, FLBuilt 1962 · S/N 18254466 N35672Leaseair LLC · Wilmington, DEBuilt 1968 · S/N 17256898 N35673Knutson Ronald J · Tacoma, WABuilt 1968 · S/N 17256899 N35675Scholand Gregory J · West Ossipee, NHBuilt 1968 · S/N 17256900 N35678Trone Gary L · Taylorville, ILBuilt 1968 · S/N 17256903 N3567FPbj Skylane LLC · Sparks, NVBuilt 1966 · S/N 18257567 N35680Pilot Studio LLC · Sabana Seca, PRS/N 17256905 N35683Dmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 17256906 N3568UCsi Aviation LLC · Wilmington, DEBuilt 1963 · S/N 18254968 N3568YAerial Adventures Demo Inc · Hopewell, VABuilt 1962 · S/N 18254468 N35690Mcauliffe Pat · Collegeville, PABuilt 1968 · S/N 17256911 N35696Beisel Johnathan · Owasso, OKS/N 17256914 N3569UHelicopter Of Columbia LLC · Columbia, SCS/N 18254969 N3569YSage Michael · Opelika, ALBuilt 1962 · S/N 18254469 N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916 N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917 N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921 N3570UDoyle Neil R · North Pole, AKBuilt 1963 · S/N 18254970 N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925 N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926 N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927 N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928 N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929 N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930 N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932 N3571YIllinois Valley Parachute Club · Carlock, ILBuilt 1962 · S/N 18254471 N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936 N35726Jh Aero LLC · Little Rock, ARS/N 17256937 N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939 N3572UFrappollo Paul M · Berryville, VABuilt 1963 · S/N 18254972

Back to AD 72-03-03 R3