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.
N712KWing John David · Guymon, OKN714TMVetter Brent E · Helena, MTN71528Little John · Hamilton, TXN7158PJinnette James · Raleigh, NCN715ACLowther Fred · Corvallis, ORN715AMVon Graff Kurt · Pennington, NJN715DMWestrum Durl Troy · Norwalk, IAN715SPWitt Edward E · Jacksonville, FLN715SSS & N Aviation Inc · Wilmington, DEN715USuper D Aviation LLC · Lafayette, ALN71681Lindstrom Bruce C · Sinclairville, NYN716ACAlexandrov Boyan · Reno, NVN717ACKcd Aviation LLC · Tonica, ILN717LVPage Wayne N · Corning, IAN718TETheis Timothy J · St Charles, ILN719S & D Aviation LLC · Pamplico, SCFirst renewal noticeN719ACZing Aviation And Marine LLC · Edgewater, FLN719MWMel Williams Aviation LLC · Fairburn, GAN71BPPantaleo Robert · Vineland, NJN71DGDorrance Stephen H · Livingston, MTN71GKMetsger J Grant · Granbury, TXN71SDRalph B Beatty LLC · Murrysville, PAN720ACKcsi Aerial Patrol Inc · Bakersfield, CAN7217KGoritchan Boris J · Duluth, MNN722SSWind Wizards Inc · El Paso, TXN723AKFrohnapfel Mark T · Cordova, AKN723CLVan Why Johnathan Ryan · Corvallis, ORN72468Grieve David C · Mountain Grove, MON72493Cook Tyler · Seldovia, AKN724MSNannenga Fredrick Jr · Hillsboro, ORN725ACFiorini Jay · Turlock, CAN725CMScholz Mark W · Atchison, KSN725HEOtt Edward C · Walnut Creek, CAN725JMRegistered aircraftN726ACGrass Roots Aviation LLC · Bend, ORN726AWPhilbin Andrew Patrick · Cleveland, OHN727FWVoler Dans La Gloire LLC · Narberth, PAN727MRUnavex Inc · Pensacola, FLN728JBBex Inc · Wilmington, DEN729JPunton Robert P · Ayr, NDN72ARDollar Douglas A · Crawford, MSN72DCopenhaver Tracy K · Anthony, KSN72DLD Air LLC · The Colony, TXN72EBVector Airmotive LLC · Frisco, TXN72KCYeilding R Edward · Florence, ALN72LFLarrabee Joey S Trustee · Holyoke, CON72QTRegistered aircraftN72YOlson Ezra · Kingman, KSN730ACHeimbach Paul A · Steamboat Springs, CON731JDReifschneider Harry III · Mesa, AZ
Back to AD 2000-25-02 R1