AD 81-13-10 R1
Registered aircraft · 4,001
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-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.
N4032HValenti David A · Salt Lake City, UTN4035HSmitr LLC · Mooresville, NCN4037HWatson Marshall · Sublette, KSN4041HInternational Air Services Inc Trustee · Carson City, NVN40441Dozier Todd A · Fairfax Station, VAN4060HDue North Productions Inc · Santa Monica, CAN40661Barkay Ido M · Anchorage, AKN40667Nelson Bradley C · Williston, NDN40684Johnson Jeff · Wasilla, AKN40686Bentley Aviation Services LLC · Lewes, DEN40689Combs Christopher G · Durham, CAN4068QAerotechnics Aviation Inc · GloucestershireN40692Rocky Mountain Distributing LLC · Buffalo, MTN406NDUS & Global Technologies LLC · Tulsa, OKN407Lyford Charles A IV · Bellevue, WAN4079QAero Fliers LLC · Kalispell, MTN4087HHarmonic Air LLC · Portland, ORN408LABeach Bound Flyers LLC · Mountain Brk, ALN408NDKnowlton Dane F · Camden, ALN408XQuint Jeane E · Janesville, WIN4093HWilliams Charles · Wolfeboro, NHN4094HRichardson Scott A · Kalispell, MTN4096VWtw Air LLC · Houston, TXN4097H1234g LLC · Topeka, KSN4098HLance Aero Inc · Mechanicsburg, PAN409THQualitair LLC Trustee · MichelstadtN40APCaelus Air LLC · Sheridan, WYN40ARBock Owen · Grand Rapids, MIN40CLPowell Sherman B · Pulaski, TNN40FMKiessling Jay J · Erie, PAN4114QAerofeather Aviation Inc · Suffolk, VAN41184Airwings Inc Trustee · Wilmington, DEN411AKWohnoutka Daniel P · Bolivar, MON411TABenz Christopher · Seattle, WAN4123CAja Leasing LLC · Union, MON4128UMiles David Trevor · Colfax, CAN412MMChen Kevin · San Antonio, TXN4135ZSsk Ventures LLC · Eagle, CON4138WK2 Aviation LLC · Sanford, NCN4139LCj Horizons LLC · Amboy, MNN413ZMEncore Aviation LLC · Terre Haute, INN4142RValiair Lc Trustee · Casper, WYN4142VLuccarelli Christopher · Merrimack, NHN4143NHouk Nathan · Morrisonville, NYN4145BBas Part Sales LLC · Greeley, CON414JHTravel Direct LLC · Montevideo, MNN41555Oleary John J III · Corpus Christi, TXN4159FEngstrom Thor Eric · Rogers, ARFirst renewal noticeN415JMColorado Seneca LLC · Salida, CON415SVPoytress Earl F Jr · Montrose, CO
Back to AD 81-13-10 R1