Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N845KACrowther Air LLC · Fort Myers, FLBuilt 2013 · S/N FL-845 N845LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 525-1062 N845NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40579 N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342 N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16 N846DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31957 N846FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0154 N846NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31101 N846YTTrue Drilling LLC · Casper, WYBuilt 2008 · S/N FL-617 N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847 N847DBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N BE-91 N847DDF33a Holdings LLC · Woodbridge, VABuilt 1989 · S/N E-2498 N847DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31958 N847FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0156 N847MASouthern Airways Pacific LLC · Addison, TXFirst renewal noticeBuilt 2013 · S/N 208B5075 N847NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29575 N847TX4 Ms Holding LLC · Spring, TXBuilt 2007 · S/N 258847 N847YTTrue Drilling LLC · Casper, WYBuilt 2025 · S/N FL-1361 N8484NOhara William P · Atco, NJBuilt 1968 · S/N E-7 N8486NToledo Jet Center LLC · Swanton, OHBuilt 1968 · S/N E-16 N848BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5244 N848DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31959 N848FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0158 N848GAdmin Holdings LLC · Colleyville, TXBuilt 1998 · S/N 560-0465 N848GTTrovarsi Ltd LLC · Balch Springs, TXBuilt 2008 · S/N FL-577 N848NAsf Aviation LLC · Cortlandt Manor, NYBuilt 1998 · S/N 258371 N848NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31103 N849DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31960 N849FEFederal Express Corporation · Memphis, TNS/N 208B0162 N849NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33213 N849UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-1006 N84AKMetro Aviation Inc · Shreveport, LABuilt 1977 · S/N E-1167 N84BReturnlogic Inc · Apollo Beach, FLBuilt 1984 · S/N E-2146 N84BAA & W Aviation LLC · Lafayette, LABuilt 2007 · S/N 525-0645 N84BDWhite Birch Transportation · Lee, NHBuilt 2002 · S/N 20800353 N84BEVelasquez Daniel A · Winter Park, FLBuilt 1983 · S/N E-2114 N84BFEvans Timothy Kent · Fremont, NCBuilt 1983 · S/N E-2112 N84CANeojet N84ca LLC · Reno, NVBuilt 1976 · S/N BB-166 N84DZTextron Aviation Inc · Wichita, KSS/N 208B5978 N84FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 002 N84JGTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 2000 · S/N 258507 N84JHFlycarolina LLC · Concord, NCBuilt 1984 · S/N 650-0062 N84JLChieftain Equipment LLC · Longview, TXBuilt 1980 · S/N LA-18 N84LELife Logistics LLC · Chesterfield, MOS/N FL-483 N84LGLanding Gear 7 LLC · Bossier City, LABuilt 1984 · S/N S550-0013 N84NRSs Jets LLC · Wildwood, GAS/N 525-1045 N84PCAviation Enterprises LLC · Longwood, FLBuilt 1981 · S/N BB-860 N84RSanford David G · Knoxville, TNBuilt 1977 · S/N E-1146 N84TJUsaircraft Inc · Newark, DES/N 188 N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484

Back to AD 2006-16-18 R1