Registered aircraft · 369

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:89-02-12-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:89-02-12-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:89-02-12-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:89-02-12-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:89-02-12-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:89-02-12-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.

N40VCFuerza Regida Corp · San Bernardino, CABuilt 1997 · S/N 1316 N411LTKent Aviation LLC · Midland, TXBuilt 1998 · S/N 1344 N411YMRida Realty Investments Corp · Houston, TXBuilt 2003 · S/N 1512 N412JDNormandy'S Triumph LLC · Tampa, FLBuilt 1992 · S/N 1188 N414VGBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 1117 N415LTTc Business Aviation LLC · San Francisco, CABuilt 1999 · S/N 1367 N415MA8 Windows LLC · Reno, NVBuilt 2001 · S/N 1463 N41SCWorld Tech Air 23 LLC · Valencia, CABuilt 1990 · S/N 1144 N424JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1444 N428KSSn 1360 LLC · Wilmington, DEBuilt 1999 · S/N 1360 N429CGRica Air LLC · Castaic, CABuilt 2002 · S/N 1499 N429DDAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1996 · S/N 1293 N432HCFast Bird LLC · Wilmington, DEBuilt 1995 · S/N 1262 N435HCAerobat Ventures LLC · Phoenix, AZBuilt 2001 · S/N 1450 N437GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 1437 N442WWAb Jet Co Vii LLC · Metairie, LABuilt 2001 · S/N 1442 N444QCGulfstream Giv-1411 LLC · Wilmington, DEBuilt 2000 · S/N 1411 N444QGQuad/Air LLC · Sussex, WIBuilt 2001 · S/N 1453 N445MDMalcolm Aviation LLC · San Francisco, CABuilt 1999 · S/N 1366 N44CEEvergreen Executive Holdings LLC · North Oaks, MNBuilt 1989 · S/N 1125 N44GJN44gj LLC · Camden, DEBuilt 2003 · S/N 1508 N44GVN44gv LLC · Pacific Palisades, CABuilt 1997 · S/N 1305 N450EJPremier Air Charter Inc · Carlsbad, CABuilt 1995 · S/N 1273 N450LRRicotta Lance · Yuma, AZBuilt 1988 · S/N 1013 N450MBAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1996 · S/N 1295 N450PZN800pz LLC · Las Vegas, NVBuilt 1996 · S/N 1299 N451GAStratton Ventures LLC · Wilmington, DEBuilt 1993 · S/N 1221 N451KRAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N 1451 N455WGAlliance Aviation Group LLC · Wilmington, DEBuilt 1992 · S/N 1205 N455ZSparta Aviation Group LLC · Saint Petersburg, FLBuilt 1994 · S/N 1235 N457DSBest Aircraft Deals LLC · Salt Lake City, UTS/N 1077 N460AKTangier Services LLC · Mill Valley, CABuilt 2000 · S/N 1413 N472MMSmb G-IV II LLC · Longwood, FLS/N 1072 N473CWAlfa Fox X LLC · Sebring, FLBuilt 1992 · S/N 1194 N474XWashington Penn Plastic Co Inc · Washington, PABuilt 2001 · S/N 1445 N475LCIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1472 N477GG477 Aviation LLC · Beverly Hills, CABuilt 1987 · S/N 1032 N478GSIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1478 N480VRMmap LLC · Denver, COBuilt 1999 · S/N 1380 N481SCRjs Aviation LLC · Fort Myers, FLBuilt 1997 · S/N 1313 N485GMGlobal Destinations LLC · Beaumont, TXBuilt 1997 · S/N 1311 N48GLGenesis Adventures LLC · Brea, CABuilt 1988 · S/N 1052 N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336 N495WGAir Kuz LLC · Jamison, PABuilt 1993 · S/N 1214 N49RFUnited States Department Of Commerce · Lakeland, FLBuilt 1994 · S/N 1246 N4DPGreen Chair Productions Inc · Los Angeles, CABuilt 1989 · S/N 1097 N501RBLone Star Land & Cattle Co · Houston, TXBuilt 1990 · S/N 1138 N509CQBwp Aviation LLC · Nashville, TNBuilt 1993 · S/N 1233 N50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 1994 · S/N 1252 N510MGSuperior Transportation Associates Inc · Costa Mesa, CABuilt 1998 · S/N 1349

Back to AD 89-02-12 R1