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.
N7517EVanherck Glen D · Bonne Terre, MON7518BMaxwell Richard H · Grove City, PAN7518FKlassen Orvil H · Mountain Lake, MNN7519FBohlman Todd L · Lemon Grove, CAN751UGaines Charles C · Fernandina Beach, FLN7520BGreen William D · Fairbanks, AKN7521BBarnick Ryan E · Montpelier, NDN7522BTailwheelin LLC · Richland, WAN7524EWaterbury Farms · Gridley, CAN7524FRobinson Robert L Jr · Homer, AKN7525EJennings Shawn T · Chetek, WIN7526BTyree Chris L · Arley, ALN7526EKerlin Matthew D · Fredericksburg, VAN7526FMikulich Joseph · Bovey, MNN7527FProtsman Bryan D · Anchorage, AKN7528BFairley Stephen M · Petal, MSN7528FRausch Bruce Thomas · Marysville, OHN7529BTeck Roger M · Mayfield, NYN752DEEwers C Donald Trustee · Batavia, OHN7531FCanale Anthony · Friendswood, TXN7532BRimck Lloyd F · Maricopa, AZN7532FPrather Carl L · Gilroy, CAN7533BJoe Dory Aviation LLC · Star, IDN7534BMandan Enterprises LLC · Chester, CTN7534EMatta Figueroa Eduardo · Chapman, KSN75365Matthews John D · Land O Lakes, FLN75369Parker Jeffrey D · Chelsea, ALN7536ECheslik Michael S · Columbus, OHN75373Prough Steve P · Des Moines, IAN7537BParker William Scott · Barnesville, GAN7537EGallaway David P · Albany, ORN7538FSwensen Nathan E · Winnemucca, NVN7539EPierce Stephan L · Graham, TXN7539FHerkstroeter Caleb · Fairbanks, AKN753RJMeyer Christopher R · Colchester, CTN7540ECottrell Mark C · Leitchfield, KYN7540FMeierotto Noah J · Two Rivers, AKN7541BWestfall James H · Bend, ORN7542EBrasil John I · Lemon Grove, CAN7543EHyde John · Fort Worth, TXN7544FGrundy James W · West Greenwich, RIN7545BLrh Equipment LLC · Pendleton, ORN7546ELanier Dennis A · Columbus, GAN7546FPutman James G · Guntersville, ALN754ACWillis Norman R · Wilsonville, ORN7550BPomeroy Jess P · Redding, CAN7551BMcvicker Matt G · Des Moines, IAN7552EBouchard Scott A · Medford, WIN7554FJohnson Michael L · Jefferson, TXN7555ERegistration Pending · Eagle River, AKRegistration pending
Back to AD 2000-25-02 R1