Skip to content

Registered aircraft · 20,683

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031 N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030 N3524LFlight Training Aircraft LLC · Wilmington, DEBuilt 2001 · S/N 172S8809 N3524SFagersten Richard B · Sparta, NJBuilt 1963 · S/N 17250724 N35253Liu Kaiyu · Metairie, LABuilt 2001 · S/N 172S8831 N3525URandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8826 N3526JRainier Flight Service LLC · Renton, WAS/N 172S8829 N3526SKoenig Edward Executor · Dow, ILBuilt 1963 · S/N 17250726 N3527ZLw Aviation LLC · Lewes, DEBuilt 2001 · S/N 172S8807 N3528SCoyer Company Inc · Orr, MNBuilt 1963 · S/N 17250728 N352AKKwartler Anatol · Maynard, MABuilt 2003 · S/N 172S9456 N352MEFlying Start Aero Services LLC · Reno, NVBuilt 2000 · S/N 172S8587 N352SPChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9499 N35302William Benjamin LLC · Orono, MNS/N 17256701 N35308Kress Gregory A · Sharpsburg, GABuilt 1968 · S/N 17256704 N3530JChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281010 N3530SMakosteako Holding Corp · Massapequa, NYBuilt 1963 · S/N 17250730 N35313Lyon W Bruce · Carterville, ILBuilt 1968 · S/N 17256706 N35315Hubert Thomas D · Greenville, TXBuilt 1968 · S/N 17256708 N35318Wings LLC · Scottsdale, AZBuilt 1968 · S/N 17256709 N35322Vincent Zachary T · Saint George, UTBuilt 1968 · S/N 17256710 N35323Bourdon Greg · Henniker, NHBuilt 1968 · S/N 17256711 N35324Schuster Darin D · New Castle, DEBuilt 1968 · S/N 17256712 N35325Fly Cessna LLC · Peoria, AZS/N 172S8819 N35326Harrison Keith D · La Grange, NCBuilt 1968 · S/N 17256714 N3532EDubois William C · El Centro, CABuilt 1978 · S/N 17271576 N3532TNs Aviation Training And Rental Inc · Pembroke Pines, FLS/N 172S8820 N35330Wilkerson Jeffrey D · Morning Sun, IABuilt 1968 · S/N 17256715 N35332Katchmar Michael L · Canon City, COBuilt 1968 · S/N 17256717 N35337Myer Martin John Trustee · Juneau, AKBuilt 1968 · S/N 17256718 N35339University Of Alaska Anchorage · Anchorage, AKS/N 172S8891 N3533SDalton Joseph D · Circleville, UTS/N 17250733 N3533ULima 001 LLC · Muscatine, IAS/N 172S8890 N35340Jones Donald E · Hollandale, MNBuilt 1968 · S/N 17256720 N35344Sawyer James E · Urbana, OHBuilt 1968 · S/N 17256721 N35345Flight One Holdings LLC · Devils Lake, NDBuilt 1968 · S/N 17256722 N35348Jet & Rotor Aviation LLC · Sacramento, CABuilt 1968 · S/N 17256724 N35349Stammich Thomas R · South Bend, INBuilt 1968 · S/N 17256725 N3534SInfinite Air Center LLC · Albany, ORS/N 17250734 N35358N44344 LLC · Wasilla, AKBuilt 1968 · S/N 17256732 N3535QBoulton Stephen A · Eugene, ORBuilt 1973 · S/N 17261666 N35362Hicks James P · Franklin, OHBuilt 1968 · S/N 17256734 N35367Hinds Community College · Bolton, MSS/N 17281068 N3536GGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 17281048 N35371Honrud Joseph C · Cal Nev Ari, NVS/N 17256738 N35377Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17256740 N3537BDulles Aviation Inc · Bristow, VABuilt 2001 · S/N 172S8827 N3537JAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11614 N35382Steele Aviation Inc · Walnut Cove, NCBuilt 1968 · S/N 17256742 N35383Scott Mark · North Andover, MABuilt 1968 · S/N 17256743

Back to AD 90-06-03 R1