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.

N801LMGlobal Aircraft Solutions LLC Trustee · San Antonio, TXBuilt 1988 · S/N NA0409 N801NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1983 · S/N BB-1164 N801NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29565 N801PJGovoa LLC · Miami Beach, FLBuilt 1990 · S/N NA0456 N801RMBlue Skies Hawker LLC · Canton, MIBuilt 1984 · S/N 258011 N801TMajestic Enterprises Ltd · Wilmington, DEBuilt 1973 · S/N TH-330 N801TWJk Aircraft Options LLC · Aripeka, FLBuilt 1999 · S/N 20800297 N801VWN776va LLC · Wainscott, NYBuilt 2008 · S/N 20800503 N801XAWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 61781 N801XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35220 N8021PArc-170 Aviation LLC · Santa Claus, INBuilt 1990 · S/N LJ-1269 N8021WNothing Wasted Consulting LLC · Kannapolis, NCBuilt 1992 · S/N E-2700 N8026TRdz Aircraft LLC · Effingham, ILBuilt 1992 · S/N E-2701 N802AAMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0873 N802CFLitton Global LLC · Wilmington, DEBuilt 1999 · S/N 258425 N802DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31917 N802NHWiechmann August J · Hubbard, IABuilt 1992 · S/N E-2694 N802NNWilmington Trust Co Trustee · Wilmington, DES/N 31073 N802QTuskegee Leasing LLC · Sioux Falls, SDBuilt 1988 · S/N S550-0157 N802UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N FL-885 N802WJXoom Enterprises LLC · Sunny Isles Beach, FLBuilt 1984 · S/N 258008 N802XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61782 N8036VC J Logistics LLC · Dodge City, KSS/N E-2693 N8037XJ B Aviation Inc · Charlotte, NCS/N E-2705 N8038ZBas Part Sales LLC · Greeley, COBuilt 1990 · S/N E-2568 N803DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31919 N803FN803f Inc · Addison, TXBuilt 2005 · S/N 208B-1112 N803HCH J King Air LLC · Madison, GAS/N LA-99 N803JACaravan Flight Services LLC · Bayside, NYBuilt 1985 · S/N 20800016 N803JGCf Aviation Trust LLC Trustee · Wilmington, DES/N 115 N803NHCoastal Helicopters Inc · Panama City, FLBuilt 1992 · S/N E-2697 N803NLN803nl LLC · Forest, VABuilt 1998 · S/N 273 N803NNAmerican Airlines Inc · Fort Worth, TXS/N 29566 N803RKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 258003 N803SCStrom Law Firm LLC · Columbia, SCBuilt 1995 · S/N 560-0287 N803TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 27156 N803XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61797 N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724 N80404Hart Aviation LLC · Emory, TXS/N D-4 N80406Johnson Raymond · Eldridge, NDBuilt 1947 · S/N D-6 N80409Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-9 N80411Parkin Steven H · Yucca Valley, CAS/N D-11 N80412Nason David F · Kent, WABuilt 1947 · S/N D-12 N80418Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-18 N80423N80423 LLC · Palisade, COS/N D-23 N80429Cary William R · Graniteville, SCBuilt 1947 · S/N D29 N80431Biggs Aircraft Inc · Wellston, OKBuilt 1947 · S/N D-31 N80435Christopher T Hoke · Edmond, OKBuilt 1947 · S/N D-35 N80438Newhard Glenn K · Bethlehem, PABuilt 1947 · S/N D-38 N8043BT & A Aviation 2 LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2618

Back to AD 2006-16-18 R1