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.

N624BPWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 9830 N624BRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9236 N625GNPaper Airplanes 3 LLC · Scottsdale, AZBuilt 1999 · S/N 575 N625SCStryker Corp · Portage, MIBuilt 2014 · S/N 9647 N626JEMmap III LLC · Houston, TXBuilt 2001 · S/N 642 N626JJBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9617 N62FFPsalm 52:8 LLC · Dover, DEBuilt 1999 · S/N 569 N631VRDoheny Leasing Inc · Culver City, CABuilt 2001 · S/N 631 N633ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 9368 N636JSJrs Global LLC · Opa Locka, FLBuilt 2009 · S/N 9325 N641GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 641 N642GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 542 N646TBBoeing Co · Berkeley, MOBuilt 2012 · S/N 9523 N648JPRegistered aircraftS/N 6308 N64MTWindtop Inc · Dallas, TXBuilt 2010 · S/N 9391 N6508Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9429 N6509Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9669 N650ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6233 N650BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6278 N650CVVerde Capital Corp · Tempe, AZBuilt 2020 · S/N 60010 N650DJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6312 N650DYPj Holdco LLC · New York, NYBuilt 2018 · S/N 6336 N650FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 6268 N650GWOzora Inc · Wilmington, DEBuilt 2018 · S/N 6341 N650HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 6097 N650NB650 Nb LLC · Chicago, ILBuilt 2016 · S/N 6200 N650RHStratton Woods LLC · West Palm Beach, FLBuilt 2015 · S/N 6154 N650RVTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 9861 N650VCU S Bank Na Trustee · Hartford, CTBuilt 2016 · S/N 6244 N650WWRegistered aircraftBuilt 2016 · S/N 6228 N650XAAramco Associated Company · Houston, TXBuilt 2016 · S/N 6201 N652BADs Advisors II LLC · Oak Park, ILBuilt 2015 · S/N 6130 N654FXMirasol Capital LLC · Cleveland, OHBuilt 2016 · S/N 6196 N655FXZeitgeist Capital LLC · Cleveland, OHBuilt 2015 · S/N 6144 N656TTBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 6234 N65EQAstra Alpha 650 LLC · Newburgh, NYBuilt 2016 · S/N 6227 N65KLRegency Aviation LLC · Edgewater, MDBuilt 2004 · S/N 5035 N65NKKokoland LLC · Camden, DEBuilt 2015 · S/N 6158 N65TPAltex LLC · Lincolnwood, ILBuilt 2014 · S/N 9616 N65WLWillis Lease Finance Corp · Coconut Creek, FLBuilt 2001 · S/N 9089 N660FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 6249 N661FXCopperwood Asset Management Lp · Cleveland, OHBuilt 2018 · S/N 6318 N661HNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 60061 N662FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 6148 N664FXPlm Services LLC · Cleveland, OHBuilt 2018 · S/N 6325 N667BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 9618 N667FXTexas All Seasons Heavy Equipment LLC · Cleveland, OHBuilt 2016 · S/N 6203 N667JDWch Aa Inc · White Plains, NYBuilt 2018 · S/N 9820 N668BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 9842 N669FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 6343

Back to AD 98-24-03 R1