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.
N3096ESilver Hair Air LLC · Fairfax, VAN3097EBean James P · Tulsa, OKN30PCHaas Brent R · Willcox, AZN30SBFlare LLC · Chattanooga, TNN30WHAcme Aerosports Inc · Huntsville, ALN3101EVolpp J Michael · Muncie, INN3106EMiddleline Aviation Inc · Ballston Spa, NYN3107EJones Donald T Jr · Yona, GUN3108AMccutcheon Jeffery T · Clinton, LAN3109EDexter Fred H · Live Oak, FLN310WAHbhis LLC · Gnadenhutten, OHN3111ELochner Richard A · Eagle River, AKN3112EKuhn Darrell G · Irma, WIN3114ESmith Ronald M · Brawley, CAN3115EBushman Kyle P · Pleasant Hill, ORN3117EKiehle Ingrid E · Anchorage, AKN3118EJordan Michael J · Hahira, GAN311PMGullwing Research LLC · Boise, IDN31251Registration Pending · Marana, AZRegistration pendingN31252Buchholz Claus W · Haslett, MIN31256Mason Crosby H · Zebulon, NCN31257Lea Nathan · Belgrade, MTN31259Rowlett Jeffery B · Tuckerman, ARN31260Vix Aircraft Services LLC · Batesville, ARN31262Sauer Roger A · Glenburn, NDN31263Handerson Ronald J · Sitka, AKN31266Registration Pending · Wasilla, AKRegistration pending, pending cancellationN31267Kieffaber Thomas M · Sagamore Hills, OHN31268Brown Gregory J · Cordova, TNN31269Happenstance LLC · Cabot, ARN31270Kunkle James K · Santa Ynez, CAN31272Nelson Debra M · Astoria, ORN31273Haselmo Zak-Newton · Park River, NDN31280Kaster Kenny C · Prineville, ORN31281Citabria 1972 LLC · Soldotna, AKN31283Somes Jason · Santa Rosa Valley, CAN31284Allen Earl R · Cottonwood, CAN31285Ramsey Blake P · Wasilla, AKN31290Huntting Preston I · Camp Verde, AZN31292Beranek John W · Prairieburg, IAN31293Scroggins Darrel T · Springfield, MON31294Molyneux Gawen G · Yucaipa, CAN31298Rivers Jerry M · Chesterfield, SCN3129EMack Air LLC · Shelbyville, TNN312TSWoodford John E · Madison, WIN3130ECowley Shane R · Bartlett, TXN3132EBlue River Aviation LLC · Palmer, AKN31339Mceachern Robert · Tupelo, MSN3133EViall Patricia L · Scio, ORFirst renewal noticeN31346Daacke Michael L · Glen Rock, PA
Back to AD 2000-25-02 R1