AD 75-07-02
Registered aircraft · 2,162
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:75-07-02')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-07-02')
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:75-07-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-07-02') 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.
N13468Wanner Kevin M · Morristown, NJN13484Aero-Flite Corp · Murfreesboro, TNN13493Pelaez Gilberto · Chatsworth, CAN13511Meteor Aviation · Kirkland, WAFirst renewal noticeN13515412 Jw Aviation LLC · Dover, DEN1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeN13526Rolla Aero Inc · Rolla, NDN1353CMason Teresa J · Tucson, AZN13541Lowcountry Flying Club · Moncks Corner, SCN13564Cain James W · Big Rapids, MIN13565Williams Jim J · Jackson, NJN1357CSummit Concepts Inc · Wilmington, DEN13596Gary Rollin F · Dallas, TXN13597Heeter Michael · Bloomington, MNN1359CCromer Aubrey E · Anderson, SCN13612Harry Philip Scott · Asheville, NCN1361CHuckaby William C Trustee · Loudon, TNN13621Fowler Gerald · Springfield, MON13647Winn William D · Fallbrook, CAN13656Groth Abigail · Oxford, GAN13667Fuller Air Inc · Wilmington, DEN13669Hypersonic Handler Inc · Essex, IAN13681Davis Jerry L · Rural Retreat, VAN13690Dyre Daniel · Park Rapids, MNN13710Registered aircraftN1371MPlamondon Jon Trustee · Reno, NVN13733Kelleher James · Nevada City, CAN13734Red Bird Flyers LLC · Acton, MAN1373CDoft Peter · San Diego, CAN13740Gigax Steven G · Archbold, OHN13747Namund LLC · Roscommon, MIN13749Son Of Jubal Ministry LLC · Bainbridge, GAN13756Sky West Aviation Inc Trustee · Albuquerque, NMN13757Nelson Robert Brett · Point Roberts, WAN1375CConn James Michael · Alexandria, MNN1377CCavok LLC · Wilmington, DEN13804Henderson Jeannie · Colorado Springs, CON13819Avco Patrol LLC · Lyndon, KSN1381CEagle Sky Patrol Inc · Deadwood, SDN1384CRedwood Area Flyers LLC · Redwood Falls, MNN13892Meyers Alexander C · Pittsburgh, PAN138JPChang Denny · Easton, PAN138RCBardin G W · Granville, NYN13939Diessner Daniel J · New Smyrna Beach, FLN1398CBennett Eric · Warsaw, INN13HKSkycombers Flying Club Inc · Pacoima, CAN1404CAeroscalper LLC · Goshen, INN1406CMcaninch Danny Ray · Pleasant Hill, CAN1408CHaworth Michael R · Riverside, CAN1419CVetrone Troy · Wisconsin Rapids, WI
Back to AD 75-07-02