AD 98-21-21 R1
Registered aircraft · 85,612
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:98-21-21-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-21-21-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-21-21-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-21-21-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.
N2989MInternational Air Services Inc Trustee · Carson City, NVN2989UGodinez Mauricio U · San Diego, CAN2989VContessa Holdings Ltd · Cheyenne, WYN298ATAltura Holdings LLC · New Albany, MSN298GBSandhu Harpreet · Livermore, CAN298HPPendergrass Inc · Demopolis, ALN298JCNiemeijer Meindert · Coralville, IAN298MGGeorgia Aviation Authority · Eastman, GAN298NDNational Training 1 LLC · Wilmington, DEN298PWMedina Ruben F · Foothill Ranch, CAN298SHHeising Sean Allen · Billings, MTN298SMSmb Flyer LLC · Queen Creek, AZN298VBEdholm Joseph · Lino Lakes, MNN2990ATottle K M DBA · Limington, MEN2990CLyng Stephen G · Kenosha, WIN2990KGundersen Timothy A · Henderson, NVN2990UShiny Pigeon LLC · Fort Worth, TXN2991FBerryessa Alan E · Cedarville, CAN2991KHayton James B · Sedro Woolley, WAN2991LRussell Daniel · Louisville, KYN2991UNeary Joseph P · Lindenhurst, ILN2991VParsons Franklin R Jr Trustee · Kiowa, CON2991YRabska William G · Suisun City, CAN2992DArnold Scott M · Peachtree City, GAN2992RSolrei Inc · West Palm Beach, FLN2992VSheridan Jeffrey S · Lakeville, MNN2993BHillegeist Tracy · Beverly, KSN2993CFrei Jayci N · Grangeville, IDN2993DBcw Aviation LLC · Sigourney, IAN2993FDaniels Aviation Inc · Inverness, MSN2993LGoutell Carl R · Marco Island, FLN2993RSell Carl N · Spanaway, WAN2993U63 Aviation LLC · Petoskey, MIN2993YBranch Robert W · Fort Mohave, AZN2994ADicicco Matthew Trustee · Los Gatos, CAN2994DAncam Lc · West Burlington, IAN2994ESkyventure Aviation LLC · Battle Creek, MIN2994R2994r Aircraft Leasing LLC · Spanish Fork, UTN2994VJetmx Inc · Goodyear, AZN29950Nichols William K · Bainbridge, GAN29959Nail Ronald Wesley · Edmond, OKN2995BLeggat Douglas J · Manhattan, KSN2995DPapoulias Michael A · Jackson, MIN2995FCj3 Aviation LLC · Idaho Falls, IDN2995LS&S Wings And Wheels LLC · Wilmington, DEN2995QTraveling Aviators LLC · West Valley City, UTN2995RAbj Aviation LLC · Montgomery, OHN2996BSale Reported · Alton, ILSale reportedN2996CSutton Aircraft Salvage LLC · Palmer, AKN2996DParker Stephen H · Montgomery, TX
Back to AD 98-21-21 R1