Skip to content

Registered aircraft · 256

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

N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N10691Reed Kerr Aviation Inc · Wilmington, DEBuilt 1984 · S/N 34-8433050 N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N113DFRegistered aircraftBuilt 1998 · S/N 3449062 N134DSDoge Aircraft LLC · Boca Raton, FLBuilt 1982 · S/N 348233148 N134MGCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233007 N1422TRead Travis · Lumberton, TXBuilt 1982 · S/N 34-8133277 N144JKLong Island Aviators LLC · Seaford, NYBuilt 1981 · S/N 34-8133010 N15EEBorn To Fly LLC · Booker, TXBuilt 1981 · S/N 34-8133054 N15FSHappytails Aviation LLC · Fort Collins, COBuilt 1981 · S/N 34-8133046 N162FRFlying Restaurants LLC · Minot, NDBuilt 1993 · S/N 3448033 N166ABSafford Aviation Service Inc · Coolidge, AZBuilt 1981 · S/N 34-8133134 N169EBMutyala Susheel V · Bellevue, WABuilt 2001 · S/N 3449230 N170HSAero Leasing LLC · Brandon, MSBuilt 1982 · S/N 34-8233164 N17QYQuebec Yankee LLC · Tucson, AZBuilt 1981 · S/N 348133117 N1896SSky Dds LLC · Las Vegas, NVBuilt 1998 · S/N 3449088 N198CMOff Rock Aviation LLC · Lewes, DEBuilt 1981 · S/N 34-8133250 N198PSDorsing Kevin G · Othello, WABuilt 1998 · S/N 3449051 N19WERlv Industries Inc · Westerly, RIBuilt 1997 · S/N 3449037 N20WJDiversified Air Services LLC · Edmond, OKBuilt 1993 · S/N 3448027 N214GKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 34-8633001 N215EVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 348533002 N220GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3449362 N220KALexatys LLC · Laurel, DEBuilt 1982 · S/N 34-8233151 N220KCAvanti Air Co · Troy, MIBuilt 1989 · S/N 3433137 N220TGSeneca Tank Inc · Des Moines, IABuilt 2002 · S/N 3449265 N220VVSmith Peter I Trustee DBA · Ocala, FLBuilt 1989 · S/N 3433140 N222AVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233006 N226LMSun Star Aviation LLC · Oshkosh, WIBuilt 2002 · S/N 3449270 N228RMitchell Warren A · Deatsville, ALBuilt 1982 · S/N 34-8233145 N232WAFremont Motors Rocksprings Inc · Rawlins, WYBuilt 1981 · S/N 34-8233020 N240RWestex Telco LLC · Abilene, TXS/N 3449496 N245CBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 34-8333007 N24WEPake Flying Services LLC · Felton, MNBuilt 1998 · S/N 3449071 N25460Kleen Sheen IV LLC · Bowling Green, KYBuilt 1985 · S/N 34-8533041 N25ADPaxton Homes LLC · Killeen, TXBuilt 1983 · S/N 348333001 N25PDKnew Man Group LLC · New Orleans, LABuilt 1994 · S/N 3448050 N260STPitts S2b LLC · Salinas, CABuilt 1981 · S/N 34-8133047 N272AAirtrade Aviation Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedS/N 3433161 N275JMAircraft Holding Company LLC · Maine, NYS/N 34-8133221 N28BJBj Aviation Inc · Littleton, COBuilt 1996 · S/N 34-47017 N292GBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 3449224 N295RNew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133185 N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073 N30028Cc Aviation Inc · Tracy, CAS/N 34-48019 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304

Back to AD 82-04-08