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.

N80444Furmanski Stan · Encino, CAFirst renewal noticeBuilt 1947 · S/N D-44 N80445Cromley Russell B · Odessa, FLBuilt 1947 · S/N D-45 N8044UCrowe Stephen R Trustee · Lake Ozark, MOBuilt 1992 · S/N E-2708 N8045UCox Clifford J · Armada, MIBuilt 1990 · S/N E-2570 N80465Right Coast Ventures LLC · Royse City, TXBuilt 1947 · S/N D-65 N8047RBrooks Auto Parts Inc · Douglas, GAS/N E-2709 N804BHMahaska Bottling Co · Oskaloosa, IABuilt 2002 · S/N 258596 N804CCPappas John · Cave Junction, ORBuilt 1980 · S/N 305 N804CVPlastic Ingenuity Inc · Cross Plains, WIBuilt 2008 · S/N 5600804 N804DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31918 N804FEFederal Express Corporation · Memphis, TNS/N 208B0039 N804JMStarr Aviation Solutions LLC · New York, NYBuilt 2000 · S/N 258467 N804MC824 Holdco LLC · Salt Lake City, UTBuilt 2004 · S/N 258684 N804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeBuilt 1982 · S/N 344 N804NNAmerican Airlines Inc · Fort Worth, TXS/N 29567 N804RDLonestar Aviation LLC · Kalispell, MTBuilt 1993 · S/N 560-0220 N804STIal Corp · Lewes, DEBuilt 1980 · S/N 501-0146 N804TBN804tb III LLC · Stuart, FLBuilt 1999 · S/N 258438 N804THPa1 208b-0421 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0421 N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N804XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61784 N8051UChandler Christian J · Ashfield, MABuilt 1990 · S/N TH-1607 N8055RPioneer Aviation LLC · Portland, ORS/N E-2711 N8055ZAir Hatzis LLC · Baton Rouge, LABuilt 1990 · S/N E-2572 N805CJIcbs Aviation LLC · Allen, TXBuilt 2005 · S/N 525-0603 N805DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31913 N805DZSeattle Aircraft Rentals LLC · Bellevue, WABuilt 1990 · S/N 20800174 N805ELKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 208B0998 N805NHT-Bone Truck Stop Inc · Columbus, NEBuilt 1992 · S/N E-2699 N805NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31075 N805PN805p LLC · Greenwood Village, COBuilt 2011 · S/N 525-0701 N805PCRoyal Air Freight Inc · Waterford, MIS/N 55-018 N805THAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0609 N805UPN357kg LLC · Winston Salem, NCBuilt 2013 · S/N FL-887 N805VCPhillips Air Ventures LLC · Tulsa, OKBuilt 1994 · S/N 525-0076 N805XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61785 N8064NSierra Hotel Aviation LLC · Spartanburg, SCBuilt 1990 · S/N E-2578 N8068USan Diego Flight Corp · San Diego, CABuilt 1992 · S/N E-2725 N8069UV115 Aviation LLC · Mount Juliet, TNBuilt 1992 · S/N E-2727 N806CM806 Assets LLC · Horseshoe Bay, TXS/N 525-0875 N806DBSouthern Aviation LLC · Spartanburg, SCBuilt 1990 · S/N FL-19 N806DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31914 N806GJPb Air LLC · Higley, AZBuilt 2002 · S/N 258602 N806JASomething Aviation LLC · Dekalb, ILBuilt 1985 · S/N 20800072 N806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLS/N BC-22 N806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1981 · S/N BB990 N806LWSac Wild LLC · Loomis, CABuilt 1994 · S/N BB-1494 N806MNJm Soar LLC · Paradise Valley, AZBuilt 2003 · S/N 258605 N806NHWes Electric LLC · Lafayette, LABuilt 1992 · S/N E-2702 N806NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29561

Back to AD 2006-16-18 R1