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.

N403AAN403aa LLC · Fort Lauderdale, FLBuilt 1977 · S/N 501-0264 N403ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41730 N403EMMach Point Nine LLC · Phoenix, AZBuilt 1981 · S/N LJ1000 N403ETFlymehlingav LLC · Tyler, TXBuilt 1999 · S/N 560-0535 N403MLDhc6-403 Equity LLC · Palm Beach, FLBuilt 1974 · S/N 403 N403PAFergany Amr Farouk · Sebastian, FLBuilt 1980 · S/N TH-1182 N403SACalk Mark C · Troy, ALBuilt 2001 · S/N E-3407 N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842 N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202 N4047SCvj62b LLC · Hendersonville, TNBuilt 2022 · S/N 525-1121 N404AAPacific Rim Management LLC · Downey, CABuilt 1982 · S/N 362 N404BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5228 N404BYMalagamar LLC · Fort Myers, FLBuilt 1988 · S/N 650-0152 N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819 N404GCushing Stone Company Inc · Amsterdam, NYBuilt 1991 · S/N 560-0095 N404JPParish Planes LLC · Tullahoma, TNBuilt 1982 · S/N LJ-1039 N404JRBowlin & Associates Inc · Clayton, GAS/N 421C0317 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N404LFHicks Michael P Jr · Wallis, TXBuilt 1974 · S/N E-588 N404PKlump Aviation LLC · Hutto, TXBuilt 1993 · S/N E-2792 N404SFCity Wings Inc · St Thomas, VIBuilt 2007 · S/N 20800404 N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774 N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617 N405BSilver Mountain LLC · Port Alsworth, AKBuilt 2024 · S/N 208B5837 N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407 N405DDVineripe Inc · Delano, CAS/N LJ-1748 N405GVAmpaire Inc · Long Beach, CABuilt 2001 · S/N 208B0892 N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132 N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930 N405WKLasai Aviation LLC · Reston, VABuilt 2004 · S/N FL-405 N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267 N4061SHammerstrand John A · La Mesa, CAS/N E-619 N406BAndrews Alfred L · San Antonio, TXBuilt 1948 · S/N D-1411 N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N406CTCentral Virginia Aviation Inc · Petersburg, VABuilt 1985 · S/N S550-0038 N406CUSs Leasing II LLC · Eau Claire, WIBuilt 1992 · S/N 650-7010 N406EJLynch Flying Service Inc · Billings, MTS/N 560-0756 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N406LJWord Jon D · Albuquerque, NMBuilt 1981 · S/N 501-0230 N406MSilver Mountain LLC · Port Alsworth, AKBuilt 2019 · S/N 208B5558 N406PASale Reported · Rantoul, KSSale reported, canceledBuilt 1982 · S/N TH-1338 N406RD406 Aviation LLC · Lake City, FLBuilt 1992 · S/N 560-0171 N406RLSkyline Construction Services Inc · Eatonton, GABuilt 1999 · S/N LJ-1574 N406SFNew Mexico State University · Las Cruces, NMBuilt 1977 · S/N LW-218 N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578 N4077SRiedesel Lynn R · Brookings, SDBuilt 1975 · S/N E-638 N4079ABrockhoff Jonathan Allen · Sanford, NCBuilt 1999 · S/N E-3279 N407ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41731 N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511 N407GVPa1 208b-0616 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0616

Back to AD 2006-16-18 R1