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.

N46643Volunteer State Aviation LLC · College Grove, TNBuilt 1968 · S/N 17257406 N4664GMessikian Jeffrey E · East Hartford, CTBuilt 1979 · S/N 17273290 N4664LThrasher Jody R · Mesquite, TXBuilt 1966 · S/N 17254659 N4664QBartos William F · Concord, OHBuilt 1973 · S/N 17261741 N46652Trail Brian C · Diamondhead, MSBuilt 1968 · S/N 17257411 N46654Flying Sesame LLC · Tavernier, FLBuilt 1968 · S/N 17257412 N46655American Patrols Inc · Midland, TXBuilt 1968 · S/N 17257413 N46661Mensonides Timothy J · Graham, WABuilt 1968 · S/N 17257418 N46668Leaseair LLC · Wilmington, DEBuilt 1968 · S/N 17257422 N4666GN4666g LLC · Weatherby Lake, MOS/N 17273292 N4666LBrewster Cynthia R · Friendswood, TXBuilt 1966 · S/N 17254661 N4666VRegistered aircraftBuilt 1980 · S/N 172RG0356 N46675Adams James W · Sioux Falls, SDBuilt 1974 · S/N 17264189 N46677Sillman Robert J · Ashuelot, NHBuilt 1968 · S/N 17257425 N4667LRebel Road Customs LLC · Yuma, AZBuilt 1966 · S/N 17254662 N46687Buergel Christopher W · Corfu, NYBuilt 1968 · S/N 17257430 N46694Roelfs Scott T · Eagle River, AKBuilt 1968 · S/N 17257433 N46696Moses Aviation Services LLC · Uvalde, TXBuilt 1971 · S/N 17259722 N466CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280858 N466EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12655 N466MAMccreery Aviation Co Inc · Mcallen, TXS/N 172S9343 N466SRKmt Alliance LLC · Kathleen, GABuilt 1967 · S/N 17255912 N466TACavitt Michael Brent · Stephenville, TXBuilt 2003 · S/N 172S9466 N46703Klink Robert J · Oregon City, ORBuilt 1968 · S/N 17257439 N46704Vance Paul · Naples, FLBuilt 1968 · S/N 17257440 N46708Smith Kim B · Chester, SCBuilt 1968 · S/N 17257442 N46709Cloud Dancer Aviation Inc · Deland, FLBuilt 1968 · S/N 17257443 N4670GWhitewater Aviation Inc · Harrison, OHS/N 17273296 N4670VHale Joshua R · Navarre, FLBuilt 1980 · S/N 172RG0360 N46713Lochner Richard A · Eagle River, AKBuilt 1968 · S/N 17257446 N46715Dillingham Robert S · Soldotna, AKBuilt 1968 · S/N 17257447 N46718Webster Steven · Stroudsburg, PABuilt 1968 · S/N 17257449 N46719Cabrera Ramon F · Guttenberg, NJBuilt 1968 · S/N 17257450 N4671GJohnson Jeffrey J · Ocean Isle Beach, NCS/N 17273297 N4671LCraft William J · New Baltimore, MIBuilt 1966 · S/N 17254666 N46720Grover Gary R · Grand Marais, MNBuilt 1968 · S/N 17257451 N46721Bristol Robert W · Sandpoint, IDBuilt 1968 · S/N 17257452 N46722Tingey Brent J · Juneau, AKBuilt 1968 · S/N 17257453 N46726Taylor David W · Hot Springs, ARBuilt 1968 · S/N 17257455 N46729Thomas Mark R · Clintondale, NYBuilt 1968 · S/N 17257457 N4672GConcepcion Neftali · Fort Myers, FLS/N 17273298 N4672QScott Judith M · Spanaway, WAFirst renewal noticeS/N 17261743 N46730Zahn Christopher W · Edwardsville, ILBuilt 1968 · S/N 17257458 N46731Laurel Highlands Aeronautical Academy LLC · Latrobe, PABuilt 1968 · S/N 17257459 N46736Krantz Gwendolyn A · Advance, NCBuilt 1968 · S/N 17257460 N46737Berney John E · Morgan Hill, CABuilt 1968 · S/N 17257461 N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463 N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464 N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465 N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466

Back to AD 90-06-03 R1