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.
N2882ZKroner David S · Rock Creek, OHN2883UPaul Aviation LLC · Sault Sainte Marie, MIN2884CKuehn Wilton H III · Turtle Lake, NDN2884UEast Tenn Pilots Club Inc · Knoxville, TNN2885CCassee Udo · Anchorage, AKN2885LBlevens George A Jr · Franklin, KYN2885SWinter Thomas N · Lincoln, NEN2885UEda4 LLC · Cresson, TXN2886CParks Walter G · Chugiak, AKN2886NRose Jeffrey C · Carmichael, CAN2886UVon Linsowe David J · Vero Beach, FLN2887CKris Noone Air LLC · Wilmington, DEN2887LMello Stephen F · Ludlow, MAN2887SRobinson Andrew K · Pahrump, NVN2888UBodo Martin Trustee · Los Altos Hills, CAN2889CStowell Ronald A · Westminster, CON2889LSouthern Star Aviation LLC · Missoula, MTN2889SKinter Christopher A · Kodiak, AKN2890CSpenchen Holdings LLC · Arnaudville, LAN2890NDruskins Christina M · Hartford, WIN2890SKeyte Clinton W · Colfax, CAN2890URedley Andrew Scott · Maryville, TNN2890VTampa Bay Soaring Society Inc · Zephyrhills, FLN2891COconnell Edward P · Killingworth, CTN2891NBell Bradley · Bothell, WAN2891VSchaller Lee · New Athens, ILFirst renewal noticeN28928Tate Isaac · Yucaipa, CAN2892CPatrick John A · Los Molinos, CAN2892LSellers Michael E · Clam Gulch, AKN2893NWing Wendall E · Marion, MIN2893UMerrell Jon P · Wolcott, NYN2894LJohnson Nancy B · Vestavia Hills, ALN2894VCuthbertson Steven M · Van Alstyne, TXN2895SMaur Karandeep · Meadville, PAN2896NPfeiffer Michael D · Greenfield, INN2897LBork Joseph L · Mosier, ORN2897ZFurney Albert · Big Lake, AKN2898ECenturion Aviation Ltd · Salina, KSN2898NBaxter Gail L Jr · Rock Hill, SCN2899CMattison Mathew J · Amberg, WIN2899WWagner Paul D · Argyle, WIN289RVBohnert Ronald F · Whitewater, MON28DPMachler Lance J · Murphys, CAN28FFalkenberg Hans T · Brodnax, VAN28GHHillenburg Gary W · Jefferson, NCN28PQZelasko Edward P · Lansing, ILN28ZXDickson Kenneth R · Louisville, KYN2900NLogsdon Dale L · Alva, OKN2901DMaples Jeffrey · Wilmington, DEN2901UJanes Charles D · Cleburne, TX
Back to AD 94-05-05 R1