Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N91902Ebe Aviation LLC · Urbandale, IABuilt 1990 · S/N 4622094 N9190AAhlhorn Travis · New Braunfels, TXBuilt 1989 · S/N 32R-7887064 N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683 N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686 N9193RLos Compadres Ranch · Premont, TXBuilt 1990 · S/N 4622098 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690 N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692 N9199POther Woman LLC · Gulf Shores, ALBuilt 1990 · S/N 4622107 N919BTGeorges Thomas A · Santa Teresa, NMBuilt 1997 · S/N 27-0226 N919SPGorman Kevin V · Ebensburg, PABuilt 1999 · S/N 3257113 N91AUScreaming Duck Air LLC · Houston, TXS/N 32R-8129017 N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034 N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326 N91FBAircraft Partner Holdings Inc Trustee · BerlinBuilt 2003 · S/N 3257314 N91MKMulaii LLC · Wilmington, DEBuilt 2014 · S/N 4636647 N91PWAerial Imaging Inc · South Bend, INBuilt 1976 · S/N 31-7652102 N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693 N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004 N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700 N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706 N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707 N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008 N9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114 N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279 N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712 N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282 N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715 N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019 N921JBC&Z Aero LLC · Des Plaines, ILBuilt 1976 · S/N 32R-7780099 N921UN921un Ventures LLC · Mercer Island, WABuilt 2004 · S/N T20608501 N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716 N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718 N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719 N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721 N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012 N9225PRegistered aircraftBuilt 1967 · S/N 24-4722 N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015 N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199 N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717 N9228PShillig Vance R · Colorado Springs, COS/N 24-4726 N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727 N922BSCentral Airlines Inc · Leawood, KSBuilt 1966 · S/N 1598-207 N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017 N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004 N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729 N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017

Back to AD 81-12-06 R1