Skip to content

Registered aircraft · 671

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:2001-02-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:2001-02-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:2001-02-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:2001-02-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:2001-02-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:2001-02-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.

N826LMXuno Aviation LLC · Fort Lauderdale, FLBuilt 2019 · S/N 525-1046 N8288RFw Cielo LLC · Canton, OHBuilt 1999 · S/N 525-0348 N829BCBerry Companies Inc · Wichita, KSBuilt 2017 · S/N 525-0951 N82AEMain Street Logistics LLC · Hoover, ALBuilt 2000 · S/N 525-0412 N82BDU-Haul Business Consultants Inc · Phoenix, AZBuilt 2013 · S/N 525-0801 N830DFNella Next LLC · Auburn, CABuilt 2022 · S/N 525-1125 N8341CAir Commander LLC · Woodbury, MNS/N 525-0150 N837PFSoutheastern Red Holdings LLC · Wellington, FLBuilt 2018 · S/N 525-1010 N840PMCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 2004 · S/N 525-0541 N844MMGp Aviation LLC · Morristown, NJBuilt 2014 · S/N 525-0844 N845LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 525-1062 N84BAA & W Aviation LLC · Lafayette, LABuilt 2007 · S/N 525-0645 N84NRSs Jets LLC · Wildwood, GAS/N 525-1045 N851DBE-9 Enterprises LLC · Chattanooga, TNBuilt 1994 · S/N 525-0054 N855BBAmador Stage Lines Inc · Sacramento, CABuilt 2000 · S/N 525-0381 N855EDSky Miles LLC · Sioux Falls, SDBuilt 2014 · S/N 525-0850 N855JFg Flight LLC · Sanibel, FLBuilt 2021 · S/N 525-1093 N858DDDoss Air LLC · Mounds, ILBuilt 1993 · S/N 525-0046 N858DPDgt Aviation LLC · New Bern, NCBuilt 2015 · S/N 525-0896 N85LXWestern Stage Express LLC · Dubuque, IABuilt 2021 · S/N 525-1085 N85SCStruthoff Co Inc · San Antonio, TXBuilt 2015 · S/N 525-0898 N85VRBd Charters LLC · Henderson, TXBuilt 2001 · S/N 525-0425 N85WHM Hixson Aviation LLC · Lake Dallas, TXBuilt 2021 · S/N 525-1088 N860DBWhyriverranch LLC · Mc Leod, MTBuilt 2001 · S/N 525-0434 N861CGLolaire LLC · El Dorado Hills, CABuilt 2015 · S/N 525-0861 N869CBHpg Holdings LLC · Mesa, AZS/N 525-0453 N876MSAvoboe LLC · North Little Rock, ARBuilt 2015 · S/N 525-0876 N876UStewart James G Trustee · Pacifica, CABuilt 2018 · S/N 525-0997 N878JUfly LLC · Wilmington, DEBuilt 2005 · S/N 525-0608 N878RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 525-0914 N879SADouma LLC · Santa Teresa, NMBuilt 2022 · S/N 525-1129 N881RCCooper Companies Inc · Scottsdale, AZBuilt 2007 · S/N 525-0635 N882MZ7-Star Aviation LLC · Addison, TXBuilt 2015 · S/N 525-0882 N883MTFlywheel LLC · Austin, TXBuilt 2015 · S/N 525-0883 N8844Diamond And A Half Cattle Company LLC · Lake Havasu City, AZS/N 525-0254 N885JHO & H Air LLC · Paris, TXBuilt 2021 · S/N 525-1098 N887SBGosmartair LLC · Harrisburg, PABuilt 2015 · S/N 525-0887 N888LSLadd Sanger · Saratoga, WYBuilt 2020 · S/N 525-1048 N888RAHope Air LLC · Lewes, DES/N 525-0135 N889TAPrivate Flight II LLC · Oklahoma City, OKBuilt 2014 · S/N 525-0823 N88ADN88ad Leasing LLC · Jackson, TNBuilt 2000 · S/N 525-0404 N88LSPrince George Aviation LLC · Memphis, TNBuilt 2001 · S/N 525-0475 N890MTRauch Richard B · Wilsonville, ORBuilt 2015 · S/N 525-0890 N896TWShineair LLC · Collierville, TNBuilt 2015 · S/N 525-0894 N897MDDodson Building Group LLC · Kalispell, MTBuilt 2019 · S/N 525-1035 N898GTKevoop Holdings LLC · El Dorado Hills, CABuilt 2020 · S/N 525-1059 N8RLDumbo Enterprises LLC · West Hartford, CTBuilt 2001 · S/N 525-0429 N900DSOwens Aviation Inc · Dallas, TXBuilt 1993 · S/N 525-0032 N900MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 525-1126 N901GGLong Bay Partners LLC · Missoula, MTBuilt 2015 · S/N 525-0901

Back to AD 2001-02-13