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.
N3134EMuehlstein Charles W · Stamford, TXN3136EWest William T · Clarksville, VAN3139ERainbow Flying Service LLC · Moses Lake, WAN313CEAvidash LLC · Cape Coral, FLN313MTNguyen Nhu-An T · Parkville, MDN313WFSalisbury Peter R · White Bear Lake, MNN3140EChapman Jerry L · Oakdale, MNN3144EAirpower Museum Inc · Ottumwa, IAN3147ERichardson Barry Ted · Butler, TNN3147NAgaliotis Paul E · San Martin, CAN3149EBaier Warren R · Horicon, WIN314MAircraft Partner Holdings Inc Trustee · BerlinN314REvans Randall B Trustee · Fallon, NVN3153EFischer Francis P · New Oxford, PAN3154ERothwell Forest · Ironton, MNN3156EStap Scott · Bancroft, MIN315ACDuewall Danny · Midland, TXN3162EMulvania Rodney A · Linn, MON3168EKroll Richard L · Kalamazoo, MIN316ACBillings Brian · Bondurant, WYN3174CDufresne Roger T · Forest Lake, MNN3175EHarter Ryan A · Greenfield, INN3179EClark Allen J · Minnetonka, MNN317JRUnd Aerospace Foundation · Grand Forks, NDN317SDSipila Hart A · Soquel, CAN3181EWainwright Carter T · Lees Summit, MON3183EHuss Micah A · Nome, AKN3186ENorlin Lary G · Indianola, IAN3187Bentley Chris H · Tallahassee, FLN3187EGriggs Thomas E Jr · Sherman, TXN3189EWeishar Walter E · Shafter, CAN318ACAughenbaugh Alan M · Iroquois, SDN318JRFlywell Aviation LLC · Bowling Green, KYN3195CDarling Jonathan S · Pender, NEN3199EJohnston Robert D · Palmyra, MEN319SANelson Edwin L · Kingsland, TXN31MSWagon Leasing LLC · Jonesboro, ARN31SCObryant Jeffrey A · Fairbanks, AKN31SETangent LLC · Phoenix, AZN31TWHall Wendell W · Cheraw, SCN31VSJenny Timothy J · Remsen, NYN31XEverson Dustin J · Providence, RIN31YFCharliefoxtrot LLC · Farmington, MON3201EMcgavock Randall J · Camp Verde, AZN3202EBlazey James R · Palmyra, NYN3202HRegistered aircraftN3203EBaker Marty R · Noonan, NDN3204EDanford Michael S · Chickamauga, GAN320MMExplorer Aviation LLC · Birmingham, MIN3213ERedmon Ronald D · Crestwood, KY
Back to AD 2000-25-02 R1