Registered aircraft · 11,797

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.

N987ABDirty Joe Aviation LLC · Windsor, CABuilt 1978 · S/N LW-269 N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069 N987CFPeekey Lumbus LLC · Vista, CABuilt 2007 · S/N 351 N987CJM&R Air LLC · Wilmington, DEBuilt 1988 · S/N S550-0152 N987CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2001 · S/N 258557 N987FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0201 N987FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2390 N987JSAmerican Star Aviation LLC · Ithaca, NYBuilt 1999 · S/N TH-1923 N987KCAsberry Gregg J · Sidney, ARBuilt 1990 · S/N E-2556 N987MCTwa LLC · Weatherford, OKBuilt 1977 · S/N 421C0439 N987NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33247 N987RAKeith Mutscher · Georgetown, TXBuilt 2000 · S/N 208B0870 N987STTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N FL-1113 N987TTEllison Thomas Andrew · Parker, TXBuilt 1993 · S/N E-2776 N988FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2400 N988KAAero Evanson LLC · Encino, CABuilt 1988 · S/N BB-1295 N988NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31237 N988RSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 258598 N988SCPallair LLC · Harlingen, TXBuilt 1999 · S/N FL244 N988WCE S Wagner Co · Oregon, OHBuilt 1998 · S/N BB-1622 N988WPM & M Air & Ground LLC · Modesto, CABuilt 1977 · S/N 501-0050 N9898Aspen Air Montana LLC · Albuquerque, NMBuilt 1998 · S/N BB1627 N989ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33205 N989AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1982 · S/N 019 N989BMHornung Kirk F · Beavercreek, OHS/N E-964 N989BWRed Dragon Aviation LLC · Melbourne, FLBuilt 2004 · S/N 208B1058 N989CLBoligee Air LLC · Birmingham, ALBuilt 2001 · S/N 258535 N989FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0124 N989FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2403 N989LAMha Consulting LLC · Columbia, SCBuilt 1988 · S/N BB-1310 N989NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33338 N989STSix Columns Aviation LLC · Dallas, TXBuilt 2000 · S/N 258478 N98AABruno Anthony J III · Bryn Mawr, PABuilt 1985 · S/N TH-1461 N98ACPf Travel LLC · Encinitas, CABuilt 2002 · S/N 329 N98ARRyan Gordon Air LLC · Santa Ana, CABuilt 1979 · S/N LJ829 N98AVRiverway Capital LLC · Houston, TXS/N 501-0177 N98BMVs Maritime LLC · Oklahoma City, OKBuilt 1976 · S/N 193 N98HAFew 28 Aviation LLC · Greer, SCBuilt 1980 · S/N LA-34 N98HFValiair Ltd Co Trustee · Casper, WYBuilt 1973 · S/N LW-89 N98KCBelles Aviation LLC · Missoula, MTBuilt 1976 · S/N BB172 N98KSGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N LJ-1502 N98LRZ Corp Inc · Middletown, DEBuilt 1997 · S/N E-3126 N98MNMohawk Northeast Inc · Plantsville, CTBuilt 1992 · S/N FL-88 N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131 N98RADenaina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB439 N98RLLevis Air LLC · Slidell, LABuilt 2018 · S/N 208B5469 N98SPSamaritans Purse · Boone, NCBuilt 2017 · S/N 208B5409 N98TACentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N BE-56 N98VCVictor Adventures LLC · Ottawa, OHBuilt 1998 · S/N E-3170 N98VGBarron 301p LLC · Olive Branch, MSBuilt 1977 · S/N BB-252

Back to AD 2006-16-18 R1