AD 2000-25-02 R1
Registered aircraft · 7,561
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.
N2877ZCliff Robinson Real Estate Corp · Madison, INN2878EHumphrey Daryle C · Graford, TXN2879EGriffin Douglas Trustee · Red Bluff, CAN2879ZRitchie Rex W · Lopez Island, WAN287DKHemphill Holdings LLC · Hemphill, TXN287EBBoorom Mikel E · Jackson, MIN2880GDixon Walter G · Fuquay Varina, NCN2881EDykstra Wayne A · Pipestone, MNN2883EDecker Eric Regis · Noblesville, INN2883GSmith Kenneth W · Bedford, INN2884ZSpurgeon Paul M · Brooksville, MSN2885EN2885e LLC · Sylvania, OHN2885ZMclaughlin Paul E · Mansfield, OHN2886EMcnab Jacob R · Ozark, ALN2888ZHonkomp Daniel · Euless, TXN288RTSavonen Stephen D · Ukiah, CAN2891ZSale Reported · Lantana, TXSale reportedN2894EAv Ed Consulting LLC · Edgewater, FLN2895EPritchett Flying Service LLC · Rolla, MON2895GWilkins Ranch Inc · Marsland, NEN2895ZRao Enterprises LLC · Brighton, MIN2896ZPotts Blaize D · Port Angeles, WAN2898ECenturion Aviation Ltd · Salina, KSN2899GYoungpeter David L · Spencerville, OHN289DMTros Corp · Wilmington, DEN289PSWillkris Aviation Services LLC · Smithfield, VAN289SAReed Gary · Bethel, OHN289SRFedora Lisa L · Southampton, MAN28CMFiorita Vincent L · Wooster, OHN28GMooneyham Mark · Auburn, CAN28GKMay Aviation LLC · San Diego, CAN28SESr Holdings LLC · Palmer, AKN2901EImes Thomas E · Bixby, OKN2902EEvans Jason P · Clayton, DEN2904ESchutze Curt K · Knoxville, TNN2905ZWmh Aviation LLC · Buckley, WAN2907EShuford Charles D · Orange Park, FLFirst renewal noticeN2907ZCabana Robert D · Cocoa, FLN2908EBane Alan D · Columbia, ILN2910ESlayton Michael B · Grand Haven, MIN2912EPrather Carl Lynn · Gilroy, CAN2913KSilverman Phillip E Trustee · Fullerton, CAN2914EAnderson Shad · Woods Cross, UTN2915E172-B LLC · Prairieville, LAN2916ERegistered aircraftN2917EBaxter Peter M · Prescott, AZN291ACBennett Mark A · Normangee, TXN291CAMaya Air Services LLC · Lee, NHN291DMMiller Jerry L · Garrison, NDN291RAParsons Aviation Inc · Wilmington, DE
Back to AD 2000-25-02 R1