Skip to content

Registered aircraft · 284

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

N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693 N279CFJ Jets Inc · Dover, DES/N 258642 N285XPAviation Fjaf LLC · Davie, FLBuilt 1995 · S/N 258285 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 N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523 N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515 N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461 N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669 N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273 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 N353JABasler Turbo Conversions LLC · Oshkosh, WIS/N 258729 N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452 N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373 N361CAN361ca LLC · Wilmington, DEBuilt 2005 · S/N 258734 N361LABest Friends Air LLC · Kerrville, TXBuilt 2001 · S/N 258562 N375PFConch Air LLC · Green Bay, WIBuilt 2001 · S/N 258558 N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565 N383MVSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258403 N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700 N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339 N389SRIgnite Enterprises LLC · Cerritos, CABuilt 2002 · S/N 258575 N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321 N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578 N411SCRegistered aircraftBuilt 2004 · S/N 258653 N412JADodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 258516 N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657 N423SGSworks Aviation LLC · Chicago, ILS/N 258472 N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509 N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293 N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641 N43MMAircraft Holding Solutions LLC · Newark, DEBuilt 2001 · S/N 258543 N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628 N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524 N444JFBod Aviation LLC · Los Angeles, CABuilt 1999 · S/N 258431

Back to AD 98-11-13