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.
N741DJBruce David Alan · Jupiter, FLN741PDRocky Mountain Aviation Service LLC · Dolores, CON742ASA2g International LLC · San Juan Capo, CAN742PDMers Timothy W · Haughton, LAN743ASA2g International LLC · San Juan Capo, CAN744ACBemo LLC · Rogers, ARN745ASA2g International LLC · San Juan Capo, CAN745MAStrategic Health Inc · Sandy, UTN746ASA2g International LLC · San Juan Capo, CAN747AYYoder Construction Inc · Treynor, IAN747FNInternational Air Services Inc Trustee · Carson City, NVN747JGGray James W · Broomfield, CON747MRParkset Air Inc · Jupiter, FLN747RCConti Richard T · Orinda, CAN749LWLease One LLC · Lafayette, INN74BLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN74JHAuermann John E · New Smyrna Beach, FLN74LCommunity And Faith Initiatives · Phoenix, AZN74SESoutheast Wood Inc · Montgomery, ALN74WTOrriserv LLC · Prior Lake, MNN74YWBresette Matt T · Gretna, NEN750GCSquid 10 LLC · Gulfport, FLN75120Kratzer Edgar · New Port Richey, FLN751RVCollins Albert A Jr · Baton Rouge, LAN75391Brennan Matthew J · Loveland, OHN753CZWalsh Kevin R Trustee · Alameda, CAN7543VN7543v LLC · Moore Haven, FLN755FMSwenson Karine M · Santa Fe, NMN755MMDewberry Danny · Olivet, MIN757GVButterfield Tyler T · Wisconsin Dells, WIN7588SPeraro Thomas A · Brighton, CON758AASager Joseph M · Milford, PAN758ABBaerwolf Roy · Lake Havasu City, AZN758AFSims Hollow M · Lithonia, GAN758AJHolman David · Bishop, CAN758AKFirst Flight LLC · Titusville, FLN758ALPayne Austin · Weslaco, TXN758AMZeid Aviation LLC · Houston, TXN758APHawthorne Corporation · Richmond, VAN758ARValiair Ltd Co Trustee · Casper, WYN758ASRff Aviation LLC · Mount Clemens, MIN758BAFlying Aces Aviation LLC · Seminole, TXN758BDBoggs Richard D · Monroe, WAN758BHBlankenship Richard A · Stillwater, MNN758BKEros Aviation Inc Trustee · Wilmington, DEN758BQMccrink Joseph J · Borrego Springs, CAN758BTMikula Julie A · Half Moon Bay, CAFirst renewal noticeN758BVPhilippi Joseph E · Judith Gap, MTN758BYOdom Bobby R · Berry, ALN758CBRegistration Pending · Merced, CARegistration pending
Back to AD 81-13-10 R1