AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N321BCGeorge Nathan V · Dardanelle, ARN321RJGritter Richard J · Catlett, VAN3223EEaa Chaptger 965 Inc · Aitkin, MNN3224EPetrocsko David · Scottdale, PAN3225EStade Joel T · Iowa Park, TXN3228EDudley Christopher · New Market, ALN3229EFleming Kirk · Spokane, WAN322ERucinski Thomas · Paramus, NJN322WMHurren Norman J · Applegate, MIN3230EFullerton Lance A · Windham, MEN3232EWohaska Sheila R · Neodesha, KSN3233TByrne Gary W DBA · Georgetown, INN3236EKarcic Tony M · Prescott, AZN3237EGauthier Evans J · Mckinney, TXN323CAChatman Ira D · Mountain Home, ARN323GSSpengler Gregg R · Potsdam, NYN323HJetzer Michael · Sherrills Ford, NCN323PRSport Flying USA Services LLC · Lititz, PAN323VWSonoran Aero LLC · Phoenix, AZN3240EWatson Bobby M · Hoxie, ARN3241EAdams Harold L · Beaver, OHN3242ERiley Glenn R · Mexico, MON3243EEvenson Don C · Moorhead, MNN3245EPisle John D · Lima, OHN3249ECapozzi Robert A · Marianna, FLN324MARollings Hills Aviation Inc · Pelham, GAN3250EWarren Howard E · Cookeville, TNN3255EKingsley Kaland W · Miller, MON325BEPerformance Backcountry Aviation LLC · Zionsville, INN3264EWarrior Aviation LLC · Dollar Bay, MIN3269EGibbs Robert I · Ravenswood, WVN3276EWhite Mark E · Cold Spring, NYN3277EPerkins Gary A · Polson, MTN327BEBlack Swamp Flyers LLC · Fremont, OHN327XNew Horizon Aviation Inc · Warwick, RIN3284EHartzler Richard B · Grandview, MON3288EMurray Richard H · Celina, OHN328MDJames Douglas M Trustee · Scottsdale, AZN3292EBeck Paul · Russell, IAN3294EJasinski Jack J · Necedah, WIN3295EMoore Gerlad J · Moscow, PAN3297EMakish Stephen J · Boca Raton, FLN329ACDean Henry C · Texarkana, TXN329CMGwb Air LLC · Waterford, MIN32BKRagen Caroline Farms LLC · Jonesboro, ARN32DHHighgate Aero Inc · Swanton, VTN32LDms Aviation Services LLC · Wildwood, MON3302EPage Alan T · Chapman, MEN330MSCanyon Airmotive LLC · Frisco, TXN330WWBaker Vernon W · Springboro, OH
Back to AD 2000-25-02 R1