AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3488ZBastian Richard L · Burns, WYN34894Whitney Ron · Indianapolis, INN34896Kidron Flying Club Pll · Wooster, OHN34897Loscheider Brian P · Cologne, MNN3489KGfh LLC · Zillah, WAN3489QPlane Progress LLC · Waterloo, IAN3489RKcsi Aerial Patrol Inc · Bakersfield, CAN3489TBlue Skies Aviation LLC · Belfast, MEN3489XHanson Jonathan · Palmer, AKN3489YHutchinson Earl F · Fairbanks, AKN348ABBledsoe Alvin · Horseshoe Bay, TXN348BPEks LLC · Lenoir City, TNN348CHAce Flight Center Inc · St Thomas, VIN348CPHaddock Tracey P · Kingstree, SCN348DProfessional Training Aircraft LLC · Wilmington, DEN348JMMelby Jon D · Chandler, AZN348JWHupp Patrick · Gladstone, MON348KEEllwood Luke D · Springboro, OHN348MAWilson Ralph W Trustee · Mentor, OHN348MBClay David L · Bryceville, FLN348MKNorth Star Aviation · Mankato, MNN348PBAbu Trailers Inc · Dwight, NDN348PVVollheim Peter M · Nashua, NHN348RPWright-Piros Ruth · Carlisle, IAN348RVBayani Amir · Roswell, GAN348SKoritz Iowa Properties LLC · Key Colony Beach, FLN348SAPutman James R Jr · Kernersville, NCN348STDream Aircraft Inc · Zeeland, MIN348TFli Aero Ltd · New Lebanon, OHN348TCWilliams Ryan D · Panama City, FLN348ZPeters Edward S · Lake Placid, FLN34900Payne Richard L · Flint Hill, VAN34901Brannan Christopher L · Garberville, CAN34904Carolina Sky Aviation LLC · Charleston, SCN34905Taylor Made Enterprises LLC · Mesa, AZN34908Registered aircraftN34909Thomes Gregory L · Maple Lake, MNN3490FRegistered aircraftN3490NRegistration Pending · Prescott, AZRegistration pendingN3490RFreiberger Gary D · Fort Lauderdale, FLN3490YRouse & Rouse-Houck LLC · Gunnison, CON34910Jackson Flight Associates Inc · Sherburn, MNN34915Roberts David C · Sidney, IAN34916Denardo Stephen B · Cranston, RIN34917Chester Zechariah L · Eau Claire, MIN3491NArmstrong William · Scotts Valley, CAN3491QOuter Marker Inc · Sandy, UTN3491SApollo Aviation Inc · Mound, MNFirst renewal noticeN3491UMalchoff Kevin R · Lake View, NYN3491ZKratzenberg Robert J · Woodgate, NY
Back to AD 2007-04-19 R1