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.
N1975TCharnes Jonathan Edan · Elmwood Park, ILN1976CHarmon Ricky A · Worland, WYN1976HOkaeronut LLC · Ponca City, OKN1976KVessey Benjamin S · Fort Collins, CON1976VWilliams Thomas E · Philip, SDN1977CBerquam Paul · Rosamond, CAN1977KCartwright Edward N · Winterville, NCN1977NKeith Kaston H · El Paso, ILN1978CMyers Boyd Brent · Tazewell, TNN1978EPritchett Flying Service LLC · Rolla, MON1978ZCarleton Caleb C · Palmer, AKN1979VNixon Andrew S · Davison, MIN1979ZBebo Michael R · Kapolei, HIN197JCGood Stephen L · Churubusco, INN197KSOld Goat LLC · Wilmington, DEN197TCRegistered aircraftN1980CHaight Benjamin C Trustee · Juneau, AKN1981CMcmillan Mark A II · Franklin, TXN1983KAutumn Crucus LLC · Cincinnati, OHN1983PCarlson Andrew J · Ashville, NYN1984NStuart Steven A · Lititz, PAN1985VMiller William H Jr · Blue Mound, ILN1985ZLemke Kerry A · Healy, AKN1987CHopkins Daniel E · Austin, TXFirst renewal noticeN1987ZN1987z LLC · Jordan, NYN1988BKruckeberg Leroy A · Sanford, NCN1988CGompert Andrew B · Burwell, NEN1988EVonheeder Clinton Edwin · Plains, MTN1988NMckinney Derrill L · Rio Linda, CAN1988VMosher Dustin T · Tehachapi, CAN1988ZMessner Mark R · Chesapeake, OHN1989NAeschliman Arlie W · Tribune, KSN1989VHotchkin Derek J · Atlantic, IAN1989ZBehnke James R · Fort Collins, CON198ACHutton Lisa · Rising Star, TXN198BFRc Aero LLC · Richmond, INN1990BSky West Aviation Inc Trustee · Albuquerque, NMN1990NNovak Ed G · Cornell, ILN1991VMussman Craig · Grant Park, ILN1993CSpencer John S · Indian, AKN1994ZGoldberg Marc Fred · Chandler, AZN1995CBorror Timothy A · Wshngtn Ct Hs, OHN1995NAlabama Aircraft Management LLC · Valley Head, ALN1995VKent Thurmon Jr · Millen, GAN1996CGoodwin James A · Greeley, CON1996ZEvans Christopher L · Summerville, SCN1997CTravelaire Service Inc · Pueblo, CON1997NNewell John G · Oklahoma City, OKN1998NHarris Bill J · Evergreen, CON1998ZMilhous Richard J · Aguila, AZ
Back to AD 94-05-05 R1