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.

N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354 N8955ZSimmons Louis Crispin · Williamsburg, VABuilt 1999 · S/N TH-1897 N895DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32003 N895FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0015 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N895SFNorth East Ventures C LLC · Danielson, CTBuilt 1988 · S/N 208B0095 N896CMXrp Investments LLC · Clyde, MIBuilt 1980 · S/N BB-668 N896DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62777 N896FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0226 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N896TWShineair LLC · Collierville, TNBuilt 2015 · S/N 525-0894 N896VRTetra Trvl LLC · La Mirada, CABuilt 2003 · S/N 258640 N897ACoastal Greens Aviation LLC · Myrtle Beach, SCBuilt 1997 · S/N 258326 N897DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32004 N897FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0227 N897GVMente LLC · Seattle, WABuilt 2022 · S/N 208B5668 N897MDDodson Building Group LLC · Kalispell, MTBuilt 2019 · S/N 525-1035 N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318 N898BRElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1986 · S/N BB-1255 N898CDRare Air Aviation Services LLC · Santa Rosa, CABuilt 2007 · S/N FL-556 N898DMMeis David Bradley · Belmont, NCS/N E-3216 N898DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62778 N898GTKevoop Holdings LLC · El Dorado Hills, CABuilt 2020 · S/N 525-1059 N898JBSalesapproach Inc · Marlborough, MABuilt 1975 · S/N E-704 N898NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33225 N899BAReliance Air LLC · Conway, ARBuilt 1993 · S/N LJ-1344 N899DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32005 N899FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0235 N899JEN899je LLC · Rollins, MTS/N FL-497 N899NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2012 · S/N 31151 N899PEArkansas Jet Sales & Leasing LLC · Little Rock, ARBuilt 1994 · S/N 560-0252 N899SDRed Rock Aviation LLC · Dover, DEBuilt 1981 · S/N BB-776 N89EDPage Daniel R · Raleigh, NCBuilt 1979 · S/N E-1479 N89GPanousis Steve · Kennett, MOBuilt 1975 · S/N TH-616 N89JLDag Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N LA19 N89LRA36 Gps LLC · Boone, NCBuilt 1982 · S/N E-2058 N89MDFuturesource Capital Corp · Bismarck, NDBuilt 2002 · S/N 560-0612 N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLS/N BB-766 N89PDCaleta Ventures LLC · Richmond, TXBuilt 1979 · S/N E-1554 N89PR603 Holdings LLC · Aberdeen, SDBuilt 2002 · S/N 560-0603 N89PXRegistered aircraftBuilt 2019 · S/N FL-1180 N89TJSkywerx Aviation Inc · Blair, NEBuilt 1981 · S/N 551-0035 N89UABoard Of Trustees · Fayetteville, ARBuilt 1989 · S/N BB-1336 N89WABurris D Rob Trustee · Tucson, AZBuilt 1999 · S/N 258420 N89WCHigh Shadow LLC · Roach, MOBuilt 1992 · S/N FL-72 N8AMMraf LLC · Wilmington, DEBuilt 1977 · S/N BB-274 N8CAKamaka Air LLC · Honolulu, HIS/N 208B2329 N8DPDelta Papa Aviation LLC · Wilmington, DES/N TH-1038 N8EFMcco Inc · Tuscumbia, ALBuilt 1980 · S/N BB-721

Back to AD 2006-16-18 R1