AD 80-25-02 R2
Registered aircraft · 6,349
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:80-25-02-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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.
N8369VCentral Virginia Aviation Inc · N Dinwiddie, VAN8372VVarwig Korrey L · Peoria, ILN8374VDexter Fred M · Live Oak, FLN8375VCarll Elizabeth M · Chicago, ILN8376VKirkeby Dean A · Clark, SDN8377VWeber William A · Brodhead, WIN8378VDollins Carl E · Grosse Ile, MIN837THHager Bill · Parma, IDN83829Mile High Aviation LLC · Lewes, DEN8387VN8387v LLC · Lansing, MIN8389VNelzen Wayne K · Mulino, ORN8390VMapel Roger N · Weirton, WVN8395VVandeman Jack A · Norco, CAN83DFSchwendeman Mark W · Medina, TXN83DTAdams David V · Villa Ridge, MON83JMRutan Aircraft Flying Museum · Waller, TXN83NMMayo Michael J · Palo Alto, CAN83PCColin Patrick L · KororN83PJSupan David M · Elk Grove, CAN83RTWilliamson Tracy C · Texarkana, TXFirst renewal noticeN83TMCimino Joseph Michael · Decatur, ALN83VSherrer Eric W · Santa Paula, CAN84032Eide Donald B Trustee · Webster, MNN8405MWilson Howard C · Georgetown, TXN8409WMessam Andre · Snellville, GAN84458Petty Edwin · Clanton, ALN84520Hagedorn Matthew J · Prineville, ORN8479KMeidinger Vernon J · Zeeland, NDN847XNewhall Bud · Galt, CAN848RChristensen Cody J · Des Moines, IAN8490VCarson Joe F III · Jackson, MSN84938Shearer Don E · Madrid, IAN84DKJeffreys Joseph C · Lancaster, CAN84MKNew Horizons Aviation Inc · Goshen, INN84RWSleeman Weston H · Torrance, CAN84WDFortman James · Vancouver, WAN8500ZKreilich Jonathan E · Rogerson, IDN8501QLilly James E · Alamosa, CON8502FOrtiz John Pasqual III · Loma Linda, CAN8503Finney Michael E Trustee · Albany, INN8503JClark T J · Saint George, UTN8523PTubbs Jeffrey E · Kasilof, AKN85348Passeno Mark A · Cheboygan, MIN853CEWilford Boone · Cotter, ARN8547Carlson Cory R · Trail, MNN854KMSparrowhawk Aviation LLC · Hollister, CAN855MPPerez Mario · Oak View, CAN8564VWarfield Gerald Alan · Saltillo, MSN8567VDavey Bernard V · Eagle Lake, MNN856DASpanaflight LLC · Puyallup, WA
Back to AD 80-25-02 R2