AD 97-06-11
Registered aircraft · 5,048
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:97-06-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-11')
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:97-06-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-11') 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.
N110DBStarnes Robert D · Lavonia, GAN1110CGriffith Danny E · Little Rock, ARN1110WFoulks Alan Lee Trustee · Glendale, AZN11114Daly Arthur P · El Paso, TXN1115YSmith Phillip · Arlington, TXN111BWKnudsen Kent A · Rosenberg, TXN111CVN2xt LLC · Austin, TXN111ECGs Wings Inc · Pawnee, ILN111GMCarder Wiley C · Cameron Park, CAN111GSWiebener John W · Alva, OKN111KFrizzell Kim F · Lakeville, MNN111MSMid America Sprayers Inc · Johnson, KSN111PFFinefield James P · Cary, ILN111TMIreland David A · Eatonville, WAN111TWScott Hersmon Builder Inc · Ada, MIN111YBVanicek Nicholas Andrew · Whispering Pines, NCN1120MRichter Keith B · Oro Valley, AZN1122PTroccoli Peter Trustee · Paradise Valley, AZN1129TStapleton Thomas · Avon, INN112SPowell Paul L · Rancho Cucamonga, CAN112XAir Corriente LLC · Columbia, TNN1130MTelbo LLC · Vonore, TNN113JLHare Richard C · Northville, MIN113TWD'Antoni Gary L · Katy, TXN113VSaravis Darren S · Long Beach, CAN113XClement James G · Cresson, TXN1148TCorlett Samuel E · Fort Worth, TXN114JDVintage Motors Inc · Beattyville, KYN114SIrby Darrell L · Keller, TXN114TPGrj LLC · Lexington, SCN114WRRib Runner LLC · Sioux Falls, SDN1151XSummers Jayson V · Poway, CAN1156TAero 1 LLC · Kalispell, MTN115CA8k Entertainment Inc · Wells, MEN115MRRussell Keith M · Ivoryton, CTN1165TFlying J Partners Asset Management LLC · Casper, WYN1169TMorin Daniel P · New Harbor, MEN116FTaylor John · Mammoth Spring, ARN116TWHatfield David A · West Ossipee, NHN1170TJf Capital Series LLC · Truckee, CAN117DPMccollum Michael T · Camarillo, CAN1183ABronson Nw Inc · Redmond, ORN118NSagouspe Consulting Services LLC · Hayden, CON118VSmith Gregg W · Lake Jackson, TXN119DDColeman Russell L · St Charles, ILN119EDCentral Virginia Aviation Inc · North Dinwiddie, VAN119JBWagner Mathew J · Gary, SDN119JSFennen David A · Katy, TXN119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNN119TTBurrell Anthony · Stillwater, OK
Back to AD 97-06-11