AD 2021-24-21
Registered aircraft · 898
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
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:2021-24-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21')
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:2021-24-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21') 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.
N75WEWave Equity Partners LLC · Newport Beach, CAN76EMU Can Fly LLC · Naples, FLN770BRTvpx Ars Inc Trustee · North Salt Lake, UTN771DFPl400 LLC · Beaumont, CAN771SSSlingshot 100 LLC · Wooster, OHN774RC774rc LLC · Hillsboro Beach, FLN777JQParadise Air LLC · Anaheim, CAN777LBUnion Airspeed LLC · Cincinnati, OHN77RFGoldleaf Leasing LLC · Madison, WIN77T8c LLC · Bellevue, WAN784JPPhenomenal Sales And Marketing LLC · Butler, NJN786QAArfeen Properties Lp · Beaumont, TXN787ADBurris D Rob Co-Trustee · Tucson, AZN787PJGo Marketing Services Inc · Raleigh, NCN789GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7917Owl Aviation Services LLC · Oldsmar, FLN795WWyoming Machinery Co · Casper, WYN798TWN354rx LLC · Nashville, TNN79KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN79RZTop Flite Holdings Nc Inc · Naples, FLN7CHCmh Services Aviation Inc · Maryville, TNN7DCBlue Rock Flyers LLC · Missoula, MTN7DRRandolph Aviation LLC · Naples, FLN7FWCc Coast To Coast LLC · Corpus Christi, TXN7HMShoeson LLC · Wilmington, DEN7JWNetwork Sales And Leasing Inc · Newtown, PAN7LGGarrett Luke R · Joaquin, TXN800CSCat Scale Co · Walcott, IAN800ETUncharted LLC · Whitefish, MTN801MEmbraer Executive Aircraft Inc · Melbourne, FLN801SHBank Of Utah Trustee · Salt Lake City, UTN801WZ400 Club LLC · Marco Island, FLN804SWRegistered aircraftN805PGValti LLC · Dover, DEN807NNicholas Services LLC · Oxford, MSN808MLb Rat Condo LLC · Tampa, FLN80FEJava Wave LLC · Valparaiso, INN810NNicholas Services LLC · Oxford, MSN811HGTwo Guys And A Plane Ltd · Toledo, OHN812LPFrontline Aviation LLC · Lake Mary, FLN813EEBank Of Utah Trustee · Salt Lake City, UTN814NNicholas Services LLC · Oxford, MSN816WFBlue Parrot Capital LLC · Cabot, ARN8188EPilotinside.Com LLC · Reno, NVN818CMWheels Up Partners LLC · Ny, NYN818RPEdison Air LLC · Cleveland, OHN82161Noble Leasing LLC · Atlanta, GAN828TRPenney And Associates · Roseville, CAN82DUR & M Okieone LLC · Oklahoma City, OKN833CLLuck Stone Corp · Manakin Sabot, VA
Back to AD 2021-24-21