Skip to content

Registered aircraft · 838

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-24-03-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:98-24-03-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:98-24-03-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:98-24-03-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:98-24-03-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:98-24-03-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.

N565JTBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 525 N566PGC2d LLC · Wilmington, DEBuilt 1997 · S/N 534 N568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5340 N569DC56 Holdings LLC · Las Vegas, NVBuilt 2006 · S/N 9209 N575BGWmb Global 2018 LLC · Opa Locka, FLBuilt 2017 · S/N 9803 N585DSt Con Aviation LLC · Nashville, TNBuilt 2000 · S/N 597 N585JCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 618 N587GDGulfstream Aerospace Corp · Savannah, GABuilt 2015 · S/N 5520 N5883Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 9118 N588CV9354 Leasing LLC · West Palm Beach, FLBuilt 2009 · S/N 9354 N588GGulfstream Aerospace Corporation · Savannah, GABuilt 2014 · S/N 5488 N590EAurora Aircraft LLC · Waterford, MIBuilt 2001 · S/N 9105 N590MSMartin Sprocket & Gear Inc · Arlington, TXBuilt 2000 · S/N 9042 N591BCInternational Bank Of Commerce · Laredo, TXBuilt 1999 · S/N 577 N595ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9588 N595MPEoc Consulting LLC · Salt Lake City, UTBuilt 2018 · S/N 9822 N595TGPlatinum Equity LLC · Beverly Hills, CABuilt 2016 · S/N 6246 N599CETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9515 N599HGSunshine Sky Aviation LLC · Doral, FLBuilt 2000 · S/N 599 N599TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 668 N59DBConstellation Productions Inc · Jacksonville, FLBuilt 2000 · S/N 9073 N59JEIn59je LLC · New York, NYBuilt 1998 · S/N 559 N600JVJsv Leasing III LLC · Orlando, FLBuilt 2014 · S/N 9664 N600NBCisco Aero - N9781 LLC · Cisco, TXBuilt 2016 · S/N 9781 N600WGWeldon Granger J · Houston, TXBuilt 1998 · S/N 545 N603ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55127 N609AKPeck Ventures LLC · Henderson, NVBuilt 2009 · S/N 9346 N609RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9653 N60BJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9402 N60CCRegistered aircraftBuilt 2016 · S/N 9762 N60EWSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N 501-0319 N60PASun Meridian Riverside LLC · Brea, CABuilt 1998 · S/N 561 N610AWMs Hawker LLC · Farmington Hills, MIBuilt 2004 · S/N 9143 N610CXGlobal 9066 LLC · Wilmington, DEBuilt 2000 · S/N 9066 N610SWSteel Services Ltd · New York, NYBuilt 2016 · S/N 9733 N611BFAmb Group LLC · Atlanta, GABuilt 2016 · S/N 9774 N611JMJfm Inc · Oak Brook, ILBuilt 2003 · S/N 5001 N61318Wilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 650 N613BRRegistered aircraftBuilt 1997 · S/N 531 N613HBSigma Equity LLC · San Francisco, CABuilt 2016 · S/N 6232 N615TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9675 N616CAPioneer Hi-Bred International Inc · Wilmington, DEBuilt 2019 · S/N 5601 N616DCDjw Aviation III LLC · Monterey, CABuilt 2008 · S/N 9296 N617EAMeridien Aircraft Holdings LLC · Greenwich, CTBuilt 2002 · S/N 693 N618WFJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 9005 N6192BGlacier Aviation LLC · Westlake, TXBuilt 2015 · S/N 9708 N619GVTrans-Exec Air Service Inc · Van Nuys, CABuilt 2000 · S/N 619 N620SYGreeneagles LLC · Salt Lake City, UTBuilt 2016 · S/N 9759 N621MDBide A Wee LLC · Newark, DEBuilt 2000 · S/N 608 N622CKN622ck LLC · Sterling, VABuilt 2018 · S/N 9819

Back to AD 98-24-03 R1