Skip to content

AD 2006-16-18 R1

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.

N971ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29547 N971FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0094 N971GSE.D. Santos & Associates LLC · Wilmington, DEBuilt 1977 · S/N 501-0032 N971LLState Of Illinois · Springfield, ILBuilt 1999 · S/N FL-267 N971MBAdjacent Air LLC · Holdrege, NEBuilt 2017 · S/N 525-0971 N971NUS Government · Washington, DCS/N 208B1071 N971NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31217 N971PCMaxwell Daniel T · Glenville, PAS/N E-2123 N971PDSpyglass Aircraft LLC · Milford, CTBuilt 1997 · S/N TH-1808 N971RBleriot LLC · East Hampton, NYBuilt 1993 · S/N E-2831 N971SCAxis Transportation Services LLC · Sacramento, CABuilt 1993 · S/N LJ-1343 N9720FUnited States Of America · Melbourne, FLBuilt 1989 · S/N 20800144 N972ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30097 N972EXBallair Aviation Holdings LLC · Laud By Sea, FLBuilt 1991 · S/N 24645 N972FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0096 N972NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33334 N9738BSensor Aircraft LLC · Plano, TXBuilt 1988 · S/N 208B0097 N973ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29548 N973APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N FL-1365 N973FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0098 N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675 N973JHJdh-Im King Air LLC · Brownwood, TXS/N BB-1953 N973KSKlotz Aviation LLC · Holcomb, KSS/N FA107 N973NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31219 N973PCTennessee Beach Boyz LLC · Soddy Daisy, TNBuilt 1992 · S/N E-2698 N974AJHix Aviation LLC · Norman, OKBuilt 1996 · S/N 5600349 N974ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30098 N974QRTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2016 · S/N 208B5308 N974VVAircraft Endeavors LLC · San Antonio, TXBuilt 1979 · S/N 46974 N975ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29549 N975KASouth Dakota Department Of Transportation · Pierre, SDBuilt 2015 · S/N FL-975 N975RGRg Aviation LLC · Fort Lauderdale, FLS/N 471 N975SPSky Power LLC · Albuquerque, NMBuilt 1977 · S/N LW-263 N9760BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0102 N9761BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0107 N9762BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0109 N9766BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0112 N976ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30099 N976DGCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1981 · S/N 013 N976EWright Air Service Inc · Fairbanks, AKBuilt 2002 · S/N 208B0976 N976FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0103 N976JMBank Of Utah Trustee · Salt Lake City, UTS/N 29190 N976KCTennessee River Steel LLC · Stevenson, ALBuilt 1979 · S/N BB-601 N976NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 33243 N976RCSpirit Enterprises LLC · Greenwood, MSBuilt 1988 · S/N FA-141 N976SCAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1989 · S/N NA0435 N976SRMs Baron LLC · Oxford, MSBuilt 2000 · S/N TH-1944 N976WTMcl Partners Lp · Stockton, CABuilt 1991 · S/N 560-0115 N977AAGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1972 · S/N LJ-555 N977AVSecopsa Services LLC · Wilmington, DEBuilt 2001 · S/N 258559

Back to AD 2006-16-18 R1