AD 94-05-05 R1
Registered aircraft · 26,231
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.
N3325KBartholomew Don · Gardnerville, NVN33265Sigler Daniel E · Canby, ORN3329KCalifornia Antique Aircraft Museum DBA · San Martin, CAN3331KWright Wayne M · Chestertown, MDFirst renewal noticeN33336Swift Museum Foundation Inc · Athens, TNN3333JUrban Aviation Services Inc · Paxton, MAN3333KOrtet Jon · Valley Springs, CAN3334KOneil Thomas E · Salem, OHN33356Winfield William W · Moab, UTN33357Austin Jack L · Florence, SCN33359Watters Timothy J · Nazareth, PAN33384Daniel Michael P · Arlington, TXN33387Van Buren Karen A · Mchenry, ILN33389Walton Michael T · Hudson Falls, NYN33390Doll Mindy L · Silverdale, WAN33391Barlow Richard B · Stockbridge, GAN33395Cohn David A · Port Townsend, WAN333ADRegistration Pending · Lynchburg, VARegistration pending, pending cancellationN333CMAlbertson James M · Slocomb, ALN333DKMalinchak Louis Trustee · Bristow, OKN333GPBarnes Thomas J · Anchorage, AKN333HLNorman Monroe E · Duvall, WAN333KVScearce Richard D · Mount Vernon, IAN333LWells Kris G · Barron, WIN333MWThird Oak Aviation LLC · Statham, GAN333QAFirth Lynn C · Auburn, NHN333RXJourneys Aviation Inc · Boulder, CON333SWatson Joseph Daniel · Middleburg, VAN333VBHumes Garrett D · Leesburg, FLN333WBGammill David R · Tyronza, ARN333WGWilliams Samantha L · Kendallville, INN33403Drag Your Tail LLC · Lewes, DEN3340ERichardson Michael T · Inver Grove, MNN3340JSteiner William Mark · Newport Beach, CAN3340NCawthorne Kelly J · Harrisburg, SDN3341VAreeckal Rejee · Mcallen, TXN33427Bohmer Timothy C · Detroit Lakes, MNN3342GWhitley Darrell L · Georgetown, TXN33438Roholt Philip C · Canton, OHN3343JAndresen Paul S · Chandler, AZN3343KSel LLC · Dover, DEN3343NFerrante Aviation Inc · Vandergrift, PAN3343VVitale Paul P · Green Valley, AZN3344KKremmling Flying Inc · Kremmling, CON3345HWhitaker David E · Canton, OHN3345NHorton Ryan R · Salem, WIN33465Mcclintock Matthew Patrick · Oscoda, MIN3349HGoranson Jan David · Cherry Valley, ILN334SVTmstar Services LLC · Lewes, DEN3351KBartholomew Don B · Gardnerville, NV
Back to AD 94-05-05 R1