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.

N48DRRonald L Anderson LLC · Amery, WIBuilt 1998 · S/N 525-0272 N48GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N LJ-1409 N48JClever Conceptz LLC · Danbury, CTS/N TH-409 N48JBN48jb LLC · Imperial, MOBuilt 1948 · S/N D-1371 N48JHFlying O Consulting LLC · Hammon, OKBuilt 1971 · S/N E-297 N48LEFerguson William T · Fayetteville, TNBuilt 1969 · S/N E-155 N48PACbc Aviation LLC · Hayden, IDBuilt 1981 · S/N BB-996 N48RFUnited States Department Of Commerce · Lakeland, FLBuilt 1981 · S/N 740 N48TIndian Springs Cattle Co Ltd · Wilmington, DEBuilt 2000 · S/N E-3320 N48TXCulater LLC · Indianapolis, INBuilt 1985 · S/N TH-1493 N48TZVisibility Unlimited LLC · Carbon, INS/N E-1804 N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254 N48WWSupercub Aviation LLC · College Station, TXBuilt 1976 · S/N E-940 N49Textron Aviation Inc · Wichita, KSBuilt 2026 · S/N FL-1362 N490SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 208B5925 N490TXHosell Aviation LLC · Rome, GABuilt 1980 · S/N LA-50 N491ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44109 N491JVCessna 205 LLC · Austin, TXBuilt 1993 · S/N LJ-1349 N4925TAir Services LLC · Spokane, WAS/N BB-1870 N492AN492a LLC · Gilbert, AZBuilt 1984 · S/N 425 N492ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44110 N492CGSwan Aviation LLC · Hattiesburg, MSBuilt 1995 · S/N 560-0308 N492DYLerma Aviation LLC · Dallas, TXBuilt 2001 · S/N 258546 N492GPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N BB-1326 N4938SAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1982 · S/N 31T-8166050 N493ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41727 N493JHBrooklyn LLC · Parker, COS/N 421C0860 N493WLarreategui Patrick A · Dayton, OHBuilt 2003 · S/N E-3493 N4947MKca Of Montana LLC · Helena, MTBuilt 1978 · S/N LJ-780 N494ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41729 N494BHEvergreen Holdings LLC · Missoula, MTBuilt 1981 · S/N LA-135 N494MAKing Lenny LLC · Fairview Park, OHBuilt 1986 · S/N FA108 N495ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41728 N495DHRedwood Management LLC · Santa Rosa, CABuilt 2004 · S/N FL-404 N495GCCunningham John · Naperville, ILBuilt 1981 · S/N E-1876 N495NMCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-781 N495SASouthern Airways Pacific LLC · Addison, TXBuilt 2026 · S/N 208B5942 N495YEaglemed LLC · Wichita, KSBuilt 2004 · S/N LJ-1707 N496JHN496jh LLC · Clovis, NMBuilt 1998 · S/N 560-0496 N496SASouthern Airways Pacific LLC · Addison, TXBuilt 2026 · S/N 208B5943 N4970MAerotrust Services Corp · Wilmington, DEBuilt 1978 · S/N E-1277 N4972MZenith Air LLC · Salome, AZBuilt 1978 · S/N E-1275 N4979MLager Eric Willard · Palos Park, ILBuilt 1978 · S/N E-1281 N497DTPond Fred C · Van Wert, OHS/N E-3569 N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296 N497LGulf Sierra Air Corp · Portola Valley, CABuilt 1984 · S/N E-2156 N497RBAircraft Registration Inc Trustee · KematenBuilt 1993 · S/N FA-228 N4982RParagon Air Group · Fort Worth, TXBuilt 1998 · S/N FL-224 N4986MLaney Construction Co Inc · Murphy, NCBuilt 1978 · S/N E-1282 N498CPConstruction Design Management LLC · Bowling Green, KYS/N TH-703

Back to AD 2006-16-18 R1