Skip to content

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

N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279 N22CPRegistered aircraftBuilt 2003 · S/N 258624 N2409KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258601 N240VN240v LLC · Wilmington, DEBuilt 1999 · S/N 258417 N241JSE D Santos & Associates LLC Trustee · Wilmington, DES/N 258652 N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066 N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368 N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567 N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237 N254SBHawker 800xp LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258616 N257PLTavaero Jet Charter Corp · Houston, TXBuilt 1990 · S/N 258167 N258MRE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258258 N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529 N25XPRd Airways LLC · Channelview, TXS/N 258572 N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580 N265JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 2004 · S/N 258699 N26TCAcme Nite LLC · Nashville, TNBuilt 2001 · S/N 258521 N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744 N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693 N279CFJ Jets Inc · Dover, DES/N 258642 N285RAAsesu Aircraft LLC · Miami, FLS/N 258221 N285XPAviation Fjaf LLC · Davie, FLBuilt 1995 · S/N 258285 N28ZFCore Projects Inc · Fresno, CAS/N NA0458 N298WB45 Srl Inc · Houston, TXBuilt 2000 · S/N 258476 N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487 N300CQHawker 4 LLC · Jensen Beach, FLBuilt 2001 · S/N 258555 N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307 N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665 N310EJZenodro At Tranquility Aviation LLC · Clermont, FLBuilt 2006 · S/N 258767 N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338 N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545 N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436 N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400 N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480 N316MFMf Property Management LLC · Hattiesburg, MSS/N 258314 N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532 N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437 N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523 N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515 N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155 N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461 N32PJRegistered aircraftN-number assigned (import), not yet registeredS/N NA0455 N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669 N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273 N338SWN338sw LLC · Midland, TXBuilt 1992 · S/N 258229 N339AVKmwflight LLC · Wilmington, DEBuilt 1994 · S/N 258255 N33BCSworks Aviation LLC · Chicago, ILBuilt 1996 · S/N 258292 N33RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 258466 N343SCMtj Aviation LLC · Mooresville, NCBuilt 1998 · S/N 258365 N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334

Back to AD 2000-08-07