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.
N8136BStanley Mark E · Paso Robles, CAN8136FRawson Aviation LLC · Ardmore, OKN8136UMoors Thomas G · Wentzville, MON8136XStevenson George Otis · Wheatland, WYN8137BKelly James E · Accord, NYN8137XHarritt Roger · Anchorage, AKN8138ANelson Richard W · Edna, TXN8138TSvoboda Patrick J · Bucyrus, KSN8138UBurner Dwight L · Mc Gaheysville, VAN8138XHarris David L · Wichita, KSFirst renewal noticeN8139BDavies Lincoln J · Oostburg, WIN8139USemanskee Grant W · Snohomish, WAN8139XMerkle Patrick G · Washington, DCN813AXColley Douglas W · Spokane, WAN813HYOcala Aviation Services Inc · Ocala, FLN813MDHanks Thomas M · Carlsbad, CAN813WPay It Forward Aviation LLC · Ione, CAN813XCColley Douglas W · Spokane, WAN81409Williams Jeremy · Searsport, MEN8140BOlson Larry G · Walnut Creek, CAN8140UAnderson Milton M · Twin Bridges, MTN8140XHubbell Carl · Crowley, TXN81415Zeman Donald G · Hinckley, MNN8141SRegistration Pending · La Porte, TXRegistration pendingN81420Dahle Timothy D · Waseca, MNN81424Wbair LLC · Wills Point, TXN8142AKiel Donald G · Whitelaw, WIN8142BJones Ronald E · Cromwell, CTN8142SRebich Jason F · Overton, NVN8142TRodriguez Pablo · Toa Baja, PRN8142UMartin Ralph Edward · Jonesboro, ARN8142VKing Kevin J · Angle Inlet, MNN8142XWhitehead Daniel · New Providence, IAN8143ALiimatainen William J · Monroe, WIN8143SElite Aeronautics LLC · Carolina, PRN8143TMatheny Larry E · Litchfield, MNN8143UJon Boyd Beard · Houston, TXN8143VCenterline Holdings Inc · Camden, DEN8144BPepper Marcus · San Antonio, TXN8144NMckee James L · Caledonia, OHN8144SRegistered aircraftN8144TShanklin Christopher G · Port Aransas, TXN8144UHansen Kermit E · Ryder, NDN8144VLundahl Frederick B · Langley, WAN8144XBeadles Scott D · Valley Springs, CAN8145AAllen John Jay · Bloomington, ILN8145BRojas Luis Alberto · Riverside, CAN8145TLobitz Walter A · Lake Almanor, CAN8145XEast Carolina Aviation LLC · Camden, NCN8146UBearce Todd A · Phoenix, AZ
Back to AD 94-05-05 R1