Registered aircraft · 58

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:2007-03-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-03-02') 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:2007-03-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-03-02')
  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:2007-03-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-03-02')
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.

N108EWDepartment Of The Air Force · Hanscom Afb, MABuilt 1994 · S/N 1256 N108RTMassachusetts Institute Technology · Lexington, MABuilt 1999 · S/N 1387 N144ABFly Evolution LLC · La Puente, CABuilt 1988 · S/N 1065 N1459AG1459 Leasing LLC · Fort Lauderdale, FLBuilt 2001 · S/N 1459 N160LDRegistered aircraftBuilt 1989 · S/N 1115 N188SAAlliance Aviation Group LLC · Wilmington, DEBuilt 1990 · S/N 1150 N1979LCabana Air LLC · Frederick, MDS/N 1480 N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098 N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432 N236CACypress Cove Air LLC · Phoenix, AZBuilt 1992 · S/N 1202 N261JDMaizenblue Express LLC · Jupiter, FLBuilt 2000 · S/N 1409 N26DJGulfstream IV-Sp Msn 1206 N26dj LLC · Wilmington, DEBuilt 1992 · S/N 1206 N273SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 1346 N291VKV-Jet Aircraft Holding Co Trustee · Dover, DES/N 1466 N299MBOne World Aviation 299 LLC · Atlanta, GAS/N 1231 N300SFModern Industrial Services Inc · Beaumont, TXBuilt 1994 · S/N 1250 N30GDCarol City Air LLC · Hialeah, FLBuilt 1993 · S/N 1228 N31GVAircraft Fidelity Corp Trustee · Dover, DEBuilt 1988 · S/N 1084 N348DJMecha Holdings LLC · Newtown Square, PABuilt 1998 · S/N 1348 N360HVTk Leasing LLC · Honolulu, HIBuilt 1999 · S/N 1375 N370RSHumble Travel LLC · Wilmington, DEBuilt 1995 · S/N 1265 N394AJGlf4 1470 LLC · Wilmington, DEBuilt 2001 · S/N 1470 N39AVBlackbird Jet LLC · Boca Raton, FLBuilt 1989 · S/N 1113 N400JZJrb Pelican Point Investments LLC · Pompano Beach, FLBuilt 1994 · S/N 1255 N400ZUEastern Stearman Inc Trustee · Leesburg, VABuilt 1986 · S/N 1009 N412JDNormandy'S Triumph LLC · Tampa, FLBuilt 1992 · S/N 1188 N414VGBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 1117 N41SCWorld Tech Air 23 LLC · Valencia, CABuilt 1990 · S/N 1144 N424JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1444 N44GJN44gj LLC · Camden, DEBuilt 2003 · S/N 1508 N450LRRicotta Lance · Yuma, AZBuilt 1988 · S/N 1013 N460AKTangier Services LLC · Mill Valley, CABuilt 2000 · S/N 1413 N478GSIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1478 N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336 N49RFUnited States Department Of Commerce · Lakeland, FLBuilt 1994 · S/N 1246 N509CQBwp Aviation LLC · Nashville, TNBuilt 1993 · S/N 1233 N50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 1994 · S/N 1252 N510SPKitty Hawk LLC · Fort Worth, TXBuilt 1993 · S/N 1183 N515RAA & E Hawker Lp · Santa Ana, CABuilt 2000 · S/N 1434 N516MCPjk Aviation LLC · Great Neck, NYBuilt 2004 · S/N 1531 N51PRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1425 N53WGAlliance Aviation Group LLC · Lawrence, KSBuilt 2003 · S/N 1505 N606PSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 1477 N675RWHighlands Group LLC · Lahaina, HIBuilt 1989 · S/N 1046 N705KBRegistered aircraftBuilt 2000 · S/N 1429 N719SASr Administrative Services LLC · Van Nuys, CABuilt 1990 · S/N 1155 N741VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1404 N74GGDwm Logistics LLC · San Luis Obispo, CABuilt 1998 · S/N 1331 N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176 N869MDEmo Systems LLC · Wilton Manors, FLBuilt 1999 · S/N 1363

Back to AD 2007-03-02