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.
N19343Goheen Gordon C · Battle Ground, WAN19345Dynan Erik J · Whitefield, NHN19346Acevedo Adriel · San Antonio, TXN1934BDrake Randy L · Greenfield, INN1934COber John · Candor, NYN1934ZKlausen Mark R · Overland Park, KSN19351Place Joseph E · Springville, NYN19355Airco Interational LLC · Arlington, WAN19358Browning Helen · Peoria, ILN1935NAscolese Michael J · Athol, MAN1935ZHubbert Leroy N · Mecosta, MIN19364Ja Flight Services LLC · Sugar Grove, ILN19367Boyer Timothy J · York, PAN1936CLalomia Vincent · Montclair, NJN19374Wilson Aviation Consulting LLC · Willis, TXN19377Caffroy Daniel R · Anchorage, AKN1937AAndrews John · Albany, GAN1937CJensen Deleigh S · Dell Rapids, SDN19380Fannin William A II · Lexington, KYN19384Armstrong Thomas J · Ann Arbor, MIN19388Kittner Robert T · Ellenville, NYN19389Clenow Mark · Brighton, MAN1938VBarnett Jeffrey S · Clayton, INN1938ZSuffern Glenn · Shady Shores, TXN1939VWheadon William J · Napa, CAN1939ZBrooks James R · Oak Grove, MON19400Bailis David P · Bethlehem, PAN19404Borden Kim L · Fair Haven, NYN19406Clark Caroline Ray · Anderson, SCN19409Owen James A · Jud, NDN1940VGregg Delvin K · Durango, CON19410Sather Evan A · Hayward, CAN19413Ahlgren Jon E · Juneau, AKN19414Bailey Brian D · Bethesda, MDFirst renewal noticeN1941WDonatelle Charles S · Edina, MNN19422Bellefontaine Georges E · Shady Shores, TXN1942CPfister Robert T · Stuart, FLN19439Technical Education Services Inc · Virginia Beach, VAN1943CLacey Miles H · Valley Springs, SDN1943ZBeauford Bryan Tyler · Anderson, MON1944C1944 Charli LLC · Bristol, CTN1944NNentwick James L Jr · East Liverpool, OHN1944ZHauser Linda L · Ulysses, KSN19451Allison Jeremy L · Chandler, AZN19453Top Flight LLC · Wilmington, DEN1945CWassman Dennis B · Moraga, CAN1945NCochran Clifford D · Soldotna, AKN1945VKellar John C · Runaway Bay, TXN19463Aviation Trust Co LLC · Oklahoma City, OKN19469Registration Pending · Summerland Key, FLRegistration pending
Back to AD 94-05-05 R1