AD 94-05-05 R1
Registered aircraft · 26,232
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.
N6123HPerla Guido F · Vashon, WAN61243Rios Leah F · Anchorage, AKN61244Smith Rex M · Marshfield, MON6124EToay Thomas E · Waterloo, WIN61251Chickasha Wings Inc · Chickasha, OKN61253Flight Gate LLC · Wilton, CAN61259Lund Michael J · Poulsbo, WAN6125EIvco Vne Consulting LLC · Wilmington, DEN6127ECardan Aircraft Services Inc · Redding, CAN6127TVan Hammers Gary C · Mukwonago, WIN61282Trimble David G · Vici, OKN61286Houseman Jeffery D · Millersville, MON61288Vanorman Curt M · Clarkesville, GAN6128EWang Tekang · Ashburn, VAN61296Coomes Scott F · Seattle, WAN61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIN6129GPeters William E · Bel Air, MDN6129KLatrobe Aviation Enterprises LLC · Youngstown, PAN612RKMalcomson Kenneth L · Cresson, TXN6130ERounds Donald W DBA · Waller, TXN61311Wood James A · Madera, CAN6131EWilliams Rick J · Cooperstown, NYN6131GCragg Gordon E · Georgetown, TXN61321Gerdes Brian K · Los Alamitos, CAN61324Wills Evan J · Lynnwood, WAN61325Zetir Mohamad · Oviedo, FLN61329Girls Love To Fly Inc · Roseville, CAN6132CSnodgrass James T · Gallipolis, OHN61333Gustafson Michael J · Minnetonka, MNN61336Evans David C · Thousand Oaks, CAN61338Flyit LLC · Camas, WAN6133KSturguess James K · Boonville, MON61345Carlson Brent A · Shelley, IDN6134HKron Howard H DBA · Clara City, MNN6134KMackenzie Stuart · Pearland, TXN61354New Vision Aviation · Fresno, CAN6135FJr Imaging Logistics Inc · Pasco, WAN61363Hulbert Stephen R · Fort Ransom, NDN61365Plane Progress LLC · Waterloo, IAN6136CRegan Corey J · Tehachapi, CAN6137GPiersol Benjamin T · Honey Brook, PAN6138GStrange Keith · Lincoln, MEN6139CDaughters Turpen A · Sun City, AZN6139EWarner Aviation LLC · Belding, MIN6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeN6139TGrad Jonathan P · Warroad, MNN6140FFluno John I · San Rafael, CAN6140GSmoketown Flight Center LLC · Smoketown, PAN6141EAbpz LLC · Mc Veytown, PAN6142EHabecker David A · Tecumseh, MI
Back to AD 94-05-05 R1