Skip to content

Registered aircraft · 40,473

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

N46696Moses Aviation Services LLC · Uvalde, TXBuilt 1971 · S/N 17259722 N4669FHoese Clinton M · Spring Branch, TXS/N 28-7725026 N466AKRuckman Jim D Jr · Anchorage, AKBuilt 1947 · S/N 12-3194 N466DSDrummond Michael S · Lewisville, NCBuilt 1978 · S/N 352-78 N466PGFlom Robert K · Manassas, VABuilt 1998 · S/N 21096 N466RBGreat Planes Aviation Inc · Bochester, MNBuilt 1981 · S/N 44-8207001 N466SHWings Over Texas Holdings LLC · Denton, TXBuilt 2004 · S/N 4496181 N466TCSale Reported · Sarasota, FLSale reportedBuilt 1965 · S/N 2989 N466YYSmith Brent A · Macomb, ILBuilt 1975 · S/N 20P 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 N4670VHale Joshua R · Navarre, FLBuilt 1980 · S/N 172RG0360 N4670WSezar Hameed Ed · Woodland Hills, CABuilt 1979 · S/N 13307 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 N4671RRudder Burt H · Alamo, NVBuilt 1966 · S/N 28-21428 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 N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430 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 N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432 N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907 N4676FSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7715059 N4676WZaid LLC · Windermere, FLBuilt 1978 · S/N 13252 N4677RFields Michael L · Rockwood, TNS/N 28-21434 N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436 N4679GFlightime Inc · Elkhart, INS/N 17273305 N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N467PEOkane James K · Noblesville, INBuilt 2013 · S/N 1 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439 N46828Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 2009 N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330 N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441

Back to AD 80-04-03 R2