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.

N938BSBlue Star Gas Fleet Services Co · Santa Rosa, CABuilt 2000 · S/N FL-287 N938NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33490 N938SBCavu 350 LLC · Stuart, FLBuilt 1998 · S/N FL-211 N939ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30083 N939BWPoky Feeders Inc · Scott City, KSBuilt 1989 · S/N FA175 N939FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0180 N939FSWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N FL-939 N939MCForever Astra Inc · Wilmington, DES/N 012 N939NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33491 N939RTInvestjet LLC · Miami, FLBuilt 1984 · S/N 650-0061 N939TWGulf Atlantic Airways Inc · Gainesville, FLBuilt 1992 · S/N 560-0185 N93ABernhard Leasing LLC · Ashland, OHBuilt 1973 · S/N LW-63 N93AMAsm Aviation LLC · Bismarck, NDBuilt 1982 · S/N LA166 N93CQNavacorp III LLC · Danbury, CTBuilt 1992 · S/N FL-89 N93CVRosebriar Holdings Corp · Dallas, TXBuilt 1993 · S/N 560-0239 N93DBForce Pressure Control LLC · Seguin, TXBuilt 1994 · S/N 560-0280 N93FSEubel Brady & Suttman Asset Management Inc · Miamisburg, OHBuilt 1999 · S/N 560-0518 N93HATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 560-0493 N93LPKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N LJ-901 N93MTJ2 Sky LLC · Encinitas, CABuilt 1972 · S/N E-335 N93SFArctic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-13 N93WTWes Tex Drilling Company · Abilene, TXBuilt 1979 · S/N BE-80 N9403QBlue Sky Baron LLC · Highlands Ranch, COBuilt 1970 · S/N TH-54 N940ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30598 N940FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0040 N940HCAll Aviation LLC · Hudson, WIBuilt 1988 · S/N BB-1303 N940NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33323 N940SWBh Aero LLC · Birmingham, ALBuilt 1994 · S/N 5250071 N940ZBMcbee Harvey Edward III · College Station, TXBuilt 1978 · S/N E-1210 N9411QWhite Tavis · Huntsville, ALBuilt 1970 · S/N TH-66 N9418QBonanza Partners LLC · Taos Ski Valley, NMBuilt 1972 · S/N E-307 N941ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29534 N941NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33232 N941RJFly Red Lodge LLC · Red Lodge, MTBuilt 1986 · S/N S550-0100 N9421FJst Management LLC · Zephyrhills, FLS/N 20800049 N9429QBuck Hollow Investments LLC · Austin, TXBuilt 1972 · S/N TH-200 N942ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30084 N942BG942bg Holdings LLC · Clovis, NMBuilt 1993 · S/N FL-98 N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731 N942NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33492 N942SWVascoe Jeffre M · Houston, TXBuilt 1981 · S/N 421C1025 N942VEndeavor Enterprises LLC · Alta Loma, CAS/N E-715 N9432QKnh LLC · Bozeman, MTBuilt 1972 · S/N E-310 N943ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30599 N943FEFederal Express Corporation · Memphis, TNS/N 208B0043 N943NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31177 N943XCCircle C Aviation II LLC · Okeechobee, FLBuilt 1991 · S/N FL-60 N9446QGalt Gulch LLC · Ann Arbor, MIBuilt 1972 · S/N TH-236 N944ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29535 N944BBSun Aviation LLC · Indianapolis, INBuilt 2003 · S/N 258611

Back to AD 2006-16-18 R1