AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N3479SCook Mark C · Hutto, TXN3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeN3480USoule Clauson D · Cooperstown, NYN3481FWells Garry L · Scotia, NEN3481SDorman Richard E · Mesa, WAN3481USmith Lowell A · Gresham, ORN3482UMitchell Philip T · Moreland, GAN3482VBorden Leon D · Arcadia, CAN3483RCentury White Worldwide Inc · Casper, WYN3483SHickey Bill J · La Veta, CON3483UPool Robert Brooks · Lake Charles, LAN3483YGrimes William H · Seabrook, SCN3484RTouch And Go Aviation LLC · Jackson, MNN3484VWeiss Elliott · Fresno, TXN3484YSport Obermeyer Ltd · Aspen, CON3485LEhalt Christopher J · Lester Prairie, MNN3485SThorp Contractors LLC · Vinita, OKN3485VMyron Alexander Tedrow · Morristown, TNN3486UZhills Pilot LLC · Zephyrhills, FLN3487SAscent Investments LLC · Kasota, MNN3487ULawser Ron · Townsend, MTN3488SBarbosa Javier · Edinburg, TXN3488VCurrier Susan · Greenvlle Jct, MEN3489RKcsi Aerial Patrol Inc · Bakersfield, CAN348ABBledsoe Alvin · Horseshoe Bay, TXN348TCWilliams Ryan D · Panama City, FLN3490FRegistered aircraftN3490GTucker Shad E · Sandia, TXN3490RFreiberger Gary D · Fort Lauderdale, FLN3490YRouse & Rouse-Houck LLC · Gunnison, CON3491SApollo Aviation Inc · Mound, MNFirst renewal noticeN3491UMalchoff Kevin R · Lake View, NYN3491VKalbermatter Guillermo A · Ventura, CAN3492UMaligator Air LLC · Missoula, MTN3493SCola William Patrick · Colfax, CAN3493VWhalen John M III · Boise, IDN3494FParadise Aviation LLC · Shoreline, WAN3494SLadder Livestock Company LLC · Savery, WYN3494YAltitude Fix Aviation LLC · Mesa, AZN3495LSaqul'Aq Air LLC · Coupeville, WAN3495RC182 Flyers LLC · Las Cruces, NMN3495S3495s LLC · Prescott, AZN3496YPincus Howard E · Grass Valley, CAN3497RWhitfield Derwin C · Picayune, MSN3497SHenry Bruce N · Bloomfield, NMN3497YBraden John C · Anchorage, AKN3498FHole In The Sky Aviation LLC · Dallas, TXN3498SEnz Vineyards Inc · Hollister, CAN3498UVintage Flyers LLC · Easton, PAN3499SSky'S Mooney LLC · Missoula, MT
Back to AD 84-10-01 R1