AD 2000-25-02 R1
Registered aircraft · 7,559
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.
N1001EBellas Bryan Turner · Geneva, OHN1002EMccurdy James R · Hampden, MEN1003EMichael Carothers · Aldie, VAN1005ESemaska Victor J · Kensington, CTN1006ESpot-Air LLC · Burlington, TXN1008EEdwards Gregory S · Guthrie, OKN1009EAven Michael D · Georgetown, INN100DPEskind Thomas O Jr · Dallas, TXN1010QBurklund Joel H · Minneapolis, MNN1010RKaneair LLC · Hayes, VAN1011TPedersen Michael · Bakersfield, CAN1012Papon Bruce · Hardtner, KSN10130Blunt Alan W · Granger, INN1013EFouts Chester L · Turner, MTN1014EMeade Lance M · Stinson Beach, CAN1017EButtanda Denise · Winchester, VAN10188Maggio Rocco M · Waupaca, WIN1018EEichman Christopher J · Lake Oswego, ORN1019ELeonard Jason · Port Saint Lucie, FLN101ACPyewacket Air LLC · Helena, MTN101BCHill Sheldon S · Red Lodge, MTN101BYRegistered aircraftN101F5g Air LLC · Rhome, TXN101RAStritzke Donald K · Caldwell, IDN101THHardy John R · Wasilla, AKN1021EYoung David S · San Jose, CAN1023EKimbrel Martin E · Oakville, WAN1025ERatzin Brendan · Pahrump, NVN1026ELampros James C · Salem, ORN1027EBuckley Joseph J · Mora, MNN1028EWalters David W · Maricopa, AZN1028TTaylor Air Service LLC · Proctor, ARN102BHVanderpool Gary W · Alamo, TXN102JVWestern Michigan University · Battle Creek, MIN10314Sweitzers Fencing Co · Felton, PAN1032EDannecker Christopher T · Lake City, FLN1034ENexga Aircraft Inc · Greensboro, NCN1035EJobe Ronald G · Sedalia, MON1036EWhite James F Jr · Abingdon, VAN1037EEssmann Matthew J · Brownsville, WIN1038DDorman Richard E · Mesa, WAN1038EFueston Vernon A · Montague, CAN103ACKrueger Douglas K Trustee · Aurora, NEN103BCPalmer David M · Jacksonville, ORN1042EPerez Alexander · Palmer, AKN10448Thompson Steven R · Pauls Valley, OKN1044EMiller James · Glen Gardner, NJN10450Grantham George F · Covington, LAN10456Registered aircraftN1045ECramer David C · Fredericksburg, VA
Back to AD 2000-25-02 R1