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.

N481HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1908 N481MCAtlas Air Inc · Purchase, NYS/N 32339 N481NSJp Flying LLC · Dover, DEBuilt 1982 · S/N 378 N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52 N4828MHodges William T · Andersonville, GABuilt 1978 · S/N E-1269 N482EAWichita State University · Wichita, KSS/N 525-0482 N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340 N4831MBoty Aero LLC · Madison, ALBuilt 1978 · S/N E-1273 N483ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 36350 N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314 N484AGBuckhorn Draw LLC · San Angelo, TXBuilt 2014 · S/N 525-0833 N484JSouthern Airways LLC · Ridgeland, MSBuilt 1994 · S/N 525-0048 N484MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1978 · S/N LJ-807 N484MMN484mm LLC · Amarillo, TXBuilt 1998 · S/N 560-0491 N484SERoberts Steve C · Richmond, TXBuilt 2007 · S/N 525-0657 N485CBBlue Pathways LLC · Statesville, NCS/N 421C0466 N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459 N485JRGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N 20800264 N485KBravo Hotel LLC · Lewes, DEBuilt 1979 · S/N BB-485 N485SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 208B5924 N485YUGen Board Of Global Ministries Of The United Metho · Atlanta, GAS/N 208B0970 N486ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44107 N486ATMeo Holdings LLC · Newark, DES/N BB-1866 N486CCFlint Transport LLC · Albany, GABuilt 1997 · S/N 525-0213 N487ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44108 N487CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2015 · S/N 525-0878 N487FPBallard Aviation Inc · Newton, KSS/N LA-98 N487JHCtgx Holdings LLC · Alpine, WYBuilt 1978 · S/N BE-43 N487NNDakota Equipment LLC · Bismarck, NDBuilt 1995 · S/N BB-1513 N487SFTexas Pacific Land Corp · Dallas, TXBuilt 2017 · S/N FL-1123 N487VCOaklr LLC · New York, NYBuilt 2001 · S/N BB-1757 N488AMByte Me Transportation Inc · Fort Pierce, FLBuilt 2003 · S/N 258648 N488DMAircraft One Ltd · Grand Rapids, MIS/N 421C-0485 N488DPRodarte Lionel · Downey, CABuilt 1974 · S/N E-522 N488FTJasper Dirt LLC · Ridgeland, SCS/N LA-137 N488JMThorup Scott I · Abilene, TXBuilt 1984 · S/N E-2140 N488KRedcell Air Inc · Miami, FLBuilt 1976 · S/N 421C0078 N488SRHard Way LLC · Dover, DEBuilt 2002 · S/N 525-0488 N488XJPartnership Management Inc · Midland, TXBuilt 1998 · S/N LJ-1527 N489CBAir Giant LLC · Watsonville, CABuilt 2002 · S/N 525-0489 N489HCJ C Cheek Contractors Inc · Kosciusko, MSFirst renewal noticeBuilt 2001 · S/N 525-0437 N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553 N48APBer Tanglewood Holdings LLC · Amarillo, TXBuilt 1999 · S/N LJ-1548 N48AZStover Aviation LLC · Dallas, GABuilt 1979 · S/N LJ-859 N48BVTrn Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1985 · S/N S550-0032 N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277 N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902 N48CSMattias Transport LLC · Tucson, AZBuilt 1986 · S/N BB-1247 N48CVAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1976 · S/N BB-189 N48DDRedstar Air Shows Inc · Discovery Bay, CABuilt 1979 · S/N 306146

Back to AD 2006-16-18 R1