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.
N538WSDodson International Parts Inc · Rantoul, KSN541RMR Sports Aviation LLC · Springfield, ORN545EBreakaway Aviation LLC · Idaho Falls, IDN548EGGrech Air LLC · Riverside, CAN549TGSmalj LLC · Atlanta, GAN54LALiebherr-America Inc · Newport News, VAN550FFCnn Aviation LLC · Lindenhurst, NYN551GMMcgrath Air LLC · Elgin, ILN551VBAircraft Two LLC · Sarasota, FLN554JMSteamboat Rentals Inc · Steamboat Springs, CON555FDIvanescu Dorin Gabriel · Windermere, FLN555NREagle Jet 300 LLC · Lehi, UTN55PPaixao LLC · Fort Lauderdale, FLN562TMValley Horizons LLC · Long Beach, CAN565BBJmh Aviation LLC · Columbus, OHN569EECorvis Aviation LLC · Englewood, CON56DJPayne Dealer Group Management Co Inc · Weslaco, TXN56SBFlight Services Investments Ltd Co · Sandia Park, NMN56TNEmbraer Executive Aircraft Inc · Melbourne, FLN571SSTrue Speed Enterprises II Inc · Brownsburg, INN572NNicholas Services LLC · Oxford, MSN573DLMakesplanesense LLC · Lutz, FLN574JSSuperior Air Charter LLC · Dallas, TXN575JSOwlvision LLC · Wilmington, DEN575RJRaci Management Co Inc · Las Cruces, NMN577JMAbr Plane LLC · Palm Beach Gardens, FLN579GTBig Sky Aviation II LLC · Sterling Heights, MIN579JSMajel Air LLC · San Diego, CAN579PGDbar Aviation LLC · San Angelo, TXN580JH46 Aviation Holdings LLC · Gallatin, TNN580JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN581BCBear Air II LLC · Piedmont, SCN581JSSuperior Air Charter LLC · Dallas, TXN583JSSuperior Air Charter LLC · Dallas, TXN584JSDavis Aviation Inc · Brandon, MSN585JSGvl Air 2 LLC · Gainesville, GAN585PCBrew Culture LLC · Jackson, WYN585TVIssue V Inc · Huntington Beach, CAN588CBIbg Aircraft Co III · Mckinney, TXN598TPAlphacraft Air LLC · Los Angeles, CAN59PW4m Air LLC · Camden, DEN5ARandolph Aviation LLC · Naples, FLFirst renewal noticeN5BBEmbraer Executive Aircraft Inc · Melbourne, FLN5NGPapa Don Aviation LLC · Bristol, VAN5SBCarver Air LLC · Albany, NYN600CSCat Scale Company · Walcott, IAN600GFPremi LLC · Solana Beach, CAN600HTLba Holdings LLC · Murray, KYN603WMWhite Mountains Capital LLC · Hanover, NHN60NFPkg Air LLC · San Diego, CA
Back to AD 2021-24-21