AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7130Lash Alvin C · Redmond, ORN7130DSorenson Gregory John · Hope, AKN7130PRieman Joel · Lompoc, CAN7130THeffron Jacob L · Little Falls, MNFirst renewal noticeN7130VKerkstra Hilary · Portage, MIN7130WRoye Bart L · Slaton, TXN7131BWeisel Jeffrey W · Prescott, AZN7131LMalof Matthew P · Falls Church, VAN7131SMaya Aircraft Holdings LLC · Lee, NHN7131YGreat Lakes Air Ventures LLC · Mason, MIN7132BConsolini Joseph · Driggs, IDN7132PJordan Kevin · Lander, WYN7132QAero Quest LLC · Olive Branch, MSN7132RGreydanus Samuel E · Holland, MIN7132VCrowley Preston R · Northport, ALN7132WN7132w LLC · Lewes, DEN7133EAir Assault Agricultural Aviation LLC · New Castle, VAN7133LHutchins Perry L · Little Rock, ARN7133QPage Aerial Service Inc · Rochelle, ILN7133VKing Mitchell Earl · Columbus, MSN7133WSale Reported · Tomahawk, WISale reported, pending cancellationN7134BSchmittle Michael D · Yermo, CAN7134CUS Flight Academy International Inc · Post, TXN7134DSprenger Mark R · Eagle River, AKN7134KMcalister Mark H · Medford, ORN7134LCook'S Aviation LLC · Conover, NCN7134PHayduk International LLC · Rockhill Furnace, PAN7134REney Brian P · Malibu, CAN7134UDalton James D · Pasadena, TXN7134WHolley Donald W · Willis, TXFirst renewal noticeN7135BHillegeist Tracy L · Beverly, KSN7135JSierra Flite LLC · Camden, DEN7135MFitts Darrell Jr · Greenbrier, ARN7135QHoman Larry E · Sigourney, IAN7135RDavey Spencer J · Spokane, WAN7135VHerkoltz Patrick Alan · Phelan, CAN7135WBudzak Gary M · Naperville, ILN7136Burch Kyle R · Overgaard, AZN7136LSchulte Barry M · Union, NJN7136QPa Lawrence LLC · Anchorage, AKN7136VHickman Jared · Bothell, WAN7136XArchangel Michael Flyers Inc · Princeville, HIN7136YSchilling Stephen V · Rockford, ILN7137LSlinkard Andrew L · Mesa, WAN7137UMalone David V · Oklahoma City, OKN7137VZelek Daniel · Wurtsboro, NYN7137WGoegebuer Brent L · Corona, CAFirst renewal noticeN7138BJlg3 LLC · Wentworth, SDN7138CDe Aviation LLC · South Wayne, WIN7138DFiebig Joel · Sebewaing, MI
Back to AD 81-18-04 R2