AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N9035XGrove Randy L · Bellefonte, PAN90361Fisher Nicholas W · Ponchatoula, LAFirst renewal noticeN90363Mahoney Gerald P · Sequim, WAN9036GSchimmel O L · Port Hueneme, CAN90373Wolff Reese · Chula Vista, CAN90376Hein A Steven · Sedona, AZN90382Richardson Kenneth S · Waterford, MIN90383Hook Kyle B · Petaluma, CAN90385Willis Roger A · Petaluma, CAN90386Collins Cody W · Palestine, TXN90387Ulmer Bryce · Locust Grove, GAN9038BJohnson William Julian · Holly Grove, ARN90394Evans Douglas B · Wimberley, TXN90395Mccall James L · La Pine, ORFirst renewal noticeN9039BSpencer Jeffrey D · Rushsylvania, OHN903KSMbk Leasing And Consulting LLC · Lakeland, FLFirst renewal noticeN9040BKrog Steven L · Hartford, WIN9042BWennen Erik J · Fairbanks, AKN90433Herman Flight Training Services LLC · Hugo, MNN90435Bowen Michael A · Pendleton, SCN9043BJohnson Darren R · Greenville, PAN9047BBooker Lisa M · Coeur D Alene, IDN9047GOdd Dale R · Aberdeen, WAN9048AGrady Keith L · Phoenix, AZN9048BMark A Lenbom · Cameron, WIN904SWAmerican Gp Inc · Nashville, TNN9050BKarge Kent K · Quincy, CAN9052BLucas John C · Sutter Creek, CAN9053AN292ac Flyers LLC · Brandon, MSN9053BKraken Aero LLC · Newport News, VAN9054BOber John A · Candor, NYN90566Holdgate Fred · Nantucket, MAN90569Larsen David R · North Pole, AKN9056AGreenough Wade E · Kasilof, AKN9056BPompeo John M · Gorham, MEN9058BHigh Daniel M · Houston, TXN9059AKown William B · Hamilton, ALN905HRMiller Darren L · Arbuckle, CAN905WSGc Aviation Services-1 LLC · Miamisburg, OHN9060BWaite Myron A · Pawlet, VTN9062ASale Reported · Wasilla, AKSale reportedN9063BPratt Patrick D · Martinisville, INN90648Warbirds Of The World Air Musuem · Los Lunas, NMN9064BHogan Frederick D · Hamilton, OHN9064EWickenheiser John · Newport, MIN90682Burton Robert E Jr · Vancouver, WAN90685Western Antique Aeroplane & Automobile Museum · Hood River, ORN90689Werner Paul W · Palm Coast, FLN9068ALucas Terry L · Oakdale, CAN9068BTherriault Charles W · Auburn, NH
Back to AD 94-05-05 R1