AD 98-21-21 R1
Registered aircraft · 85,620
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.
N2239D41 Investments Gp LLC · Sinton, TXN2239GPotter Cleve J · Fresno, CAN2239PCumbee Danny A · Geneva, ALN2239TErwin Chris L · Carson City, NVN2239ZAsc Air LLC · Neligh, NEN223BBN223bb LLC · Great Falls, VAN223BDN223bd LLC · Fresno, CAN223BECampbell Edward A · Anchorage, AKN223BTMull David L · Kathleen, GAN223DBurch Construction Co Inc · Ramona, CAN223DAAerodrome LLC · Louisville, KYN223DWSeibel Keith L · Paris, TNN223FCKimzey Edwin D Jr · La Jolla, CAN223GHMeridian Aircraft LLC · Wilmington, DEN223HWatson James E Jr · Victor, CON223JDFlynt Kevin D · Decorah, IAN223KMWithrotor Aviation Inc · Lakeview, ORN223KWMedic Choppers LLC · Springdale, ARN223LDGaston'S White River Resort Inc · Lakeview, ARN223MVallington Alexander M · Enterprise, ALN223MDPremier Engineering Inc · San Antonio, FLN223NKWandering Vet LLC · Mccook, NEN223RJCline Larry J · Beeville, TXN223SBAdams Derek · Lexington, MAN223SCSurdex Corp · Chesterfield, MON223TLZanghi Michael · Katy, TXN223TRTurner Lee W · Valdosta, GAN223WDGilliam Preston T · Philadelphia, PAN223WHPerrin James F · Bancroft, WIN223WWSan Diego Flight Training Inc · San Diego, CAN223XSaleem Sandhu M · Santa Clara, CAN223YZMeridian Aircraft LLC · Wilmington, DEN223ZAlpha Tango Aircraft LLC · Wilmington, DEN2240Twin Bonanza LLC · Meridian, IDN2240BK & D Dakota LLC · Avon, OHN2240DOhnback Ulf · Spokane, WAN2240EKellogg Jeffrey D · Adams Center, NYN2240FFenco Holdings Inc · Cheyenne, WYN2240GThunderbird Aircraft Company · Bloomington, MNN2240KBurnet David A · Quinton, ALN2240PAnderson Timothy H · Janesville, WIN2240TJudie Bear Air LLC · Bend, ORFirst renewal noticeN2241Davis Clint H · Paola, KSFirst renewal noticeN22419Gehres Shawn E · Enterprise, ALN2241BHanneman Michael W · Abilene, TXN2241FHaag Douglas A · Collierville, TNN2241GOwens Wilbur · Rch Palos Vrd, CAN2241KFlickinger Charles · Hermitage, PAN2241NBell Michael C · Sammamish, WAN2241RHappy Landings Aero LLC · Wilmington, DE
Back to AD 98-21-21 R1