AD 97-01-13
Registered aircraft · 54,837
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-01-13')
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-01-13')
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-01-13') 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-01-13') 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.
N200MCN200mc Inc Trustee · Cheyenne, WYN200NMOrr Leroy A · Tonasket, WAN200PFPrimary Flight Control LLC · Fleming Island, FLN200PSMerren R Todd DBA · Montgomery, ALN200QRPdq Flight Inc · Garden City, NYN200RXAndrews Laral B · Portland, ORN200SDKing Dwayne W · Sutton, AKN200SHHoward Steve · Jefferson City, MON200TWeishaar Walt E · Livingston, TXN200TLHusnik Brad M · Forest Lake, MNN200TNI & V Aviation LLC · Missoula, MTN200VVN200vv LLC · Pontiac, MIN200YCShady Aero LLC · Anchorage, KYN200ZKInternational Air Services Inc Trustee · Carson City, NVN20102Wings Over Texas Holdings LLC · Denton, TXN20106Atlanta Air Academy LLC · Kennessaw, GAN2010GFox Stephen A · Wasilla, AKN2010QShadow Blade Technologies LLC · Palm Bay, FLN2010XHutchinson Darrold K Trustee · Hingham, MTN20111Westcott Emily E · Sequim, WAN20115Alpha Zulu Aviation LLC · San Diego, CAN20116Paxton Roger D · Norman, NCFirst renewal noticeN2011QManzo Mario A · Sacramento, CAN2011XSalem Ricky L · Burnet, TXN20121Fly Maui LLC · Puunene, HIN20123Irungu Gitau · Charlotte, NCN20124Cerven Bohuslav Bo · Claremont, CAN20127Lewallen David H · Alexander, ARN2012EAirgo Inc · Centralia, ILN2012GMchugh Michael J Trustee · Hailey, IDN2012QOwens Joseph L · Fort Mohave, AZN2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMN20132J & L Aviation LLC · Malta, NYN20133Creative Strategies Inc · Proctorville, OHN20136Crate Inc · Humboldt, NEN2013RZinsmeyer Charles D · Llano, TXN2013XEec Group LLC · Kalispell, MTN2013YRoberts Michael R · Plano, TXN2014Blue Skies Trading Company LLC · Toledo, OHN20141Bbrrjd Inc · Wilmington, DEN20142Johnson Lindley N · Kingstowne, VAN20143Loomis Aviation LLC · Gahanna, OHN20145Avco Patrol LLC · Lyndon, KSN2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXN2014QRegistration Pending · Glennville, GARegistration pendingN2014RDaedalus Wings Inc · Malvern, OHN2014XTashjian Kirk G · Stanwood, WAN20151Binder Andrew S · Santa Barbara, CAN20154Jones 170a LLC · Bridgman, MIN20155Wild Wingdom LLC · Greenville, SC
Back to AD 97-01-13