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.
N78608Zimmerman Shawn A · Kalispell, MTN7860EBoomer Aviation Inc · Fort Walton Beach, FLN7860FVahary David J · Portage, INN7860ZGideon Troy J III · Elba, ALN78610Smith Brant P · Palmer, AKN7861FFranks Bryan S · Camarillo, CAN7861TKepo Aviation LLC · Ball, LAN7861U150 Flyers · Ithaca, MIN7861ZAmico David A · Newburyport, MAN7862XWorld Sky Academy Inc · Deland, FLN7862ZWahlberg Randy A · Pearland, TXN78630Krier Marc A · Ashland, KSN78632Ginther Michael P · Lemmon, SDN78633Wells Kris G · Barron, WIN78636Rovegno Paul C II · Burlington, NCN7863TNelson Scott J · Saline, MIN7863UNoldin Gregory Paul · Griffith, INN7864XDean John B · Chandler, AZN78654Jorgenson Brian K · Sandpoint, IDN78656Petersen Gary L · Walton, NEN78659Pearce David E Jr · Lancaster, CAN7865TN7865t LLC · Key West, FLN7865UBergstrom Lindsay B · Plymouth, MNN7865XBrennan Nicholas · Foley, ALN7865ZSchmalzel Dennis · Allenton, MIN7866EStramel Brian K · Beaverton, ORN78673Gollobit Matthew W · Pierce, NEN78675Grenier Laurent E · Monmouth, MEN78679Azevedo Manuel J · Modesto, CAN7867ELemieux Matthew T · Ettrick, WIN7867UGregersen Michael · Blackfoot, IDN78682Daddow And Sons · Nicolaus, CAN7868BBoddicker Kevin R · Luana, IAN7868UGerlach Charles T · Chloride, AZN7868XReid Brian S · Merced, CAFirst renewal noticeN7868ZKopriva Michael J · Lanexa, VAN78692Garman Benjamin N · Alzada, MTN7869THelms Brett · Valley Center, CAN786DClifton Jerry E · Sylvania, GAN786DPHensley Terry Jr · Sterling, AKN786JGFlyboyz LLC · Edgewater, FLFirst renewal noticeN7870EConner Walter L · Los Lunas, NMN7870ZNp Aviation LLC · Boulder, CON7871EValentine Barry L · Brunswick, MEN7871TPeters Harold B · Weirsdale, FLN78724Martel Tara M Personal Representative · Friday Harbor, WAN78726Petersen Randy N · East Wenatchee, WAN7872USwanson Donald W · La Center, WAN78731Griffen Thomas A · Baudette, MNN78732Kiehl Dwane · Winnett, MT
Back to AD 94-05-05 R1