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.
N2427YGreen Terry W · Binger, OKFirst renewal noticeN2428CRegistered aircraftN2428GBackcountry Guys LLC · Prescott, AZN2428RAltimeter Inc · San Marcos, TXN2428XBiggs Clifford G · Washington, UTN2428YYellen Mark A · Mohave Valley, AZN24296Cc Aviation Inc · Tracy, CAN2429EByrd David Phillip · King Salmon, AKN2429GSkydive Florida Keys Inc · Summerland Key, FLN2429LCook Shawn R · Middlebury, VTN2429UNorman Jon Frederic Jr · Pineville, LAN2429XMontpetit Steven W · New Richmond, WIN2429YTucker Robert A · Kingston, OHN242AVN242av LLC · Manassas, VAN242ENorman Brian D · Roseau, MNN242EMDay Grain Co Inc · Braman, OKN242EWEco Window Systems LLC · Medley, FLN242GDodson International Parts Inc · Rantoul, KSN242HB2hb Airways LLC · Saint Louis, MON242KABig River Air LLC · Jackson, MSN242MCMcg Aviation LLC · Miami, FLN242RG242rg LLC · Miami, FLN242RYCity Management Corp · Sunriver, ORN242VPirshafiey Nasser Charles · Trabuco Canyon, CAN242WSRowe William S · Argyle, TXN242XFour Aces Montana LLC · Missoula, MTN24305Woolsey Joseph A · Squaw Valley, CAN2430FTopaz LLC · Anchorage, AKN2430JColster John W · Centerview, MON2430LTaylor Kerry J · Childress, TXN2430UWarnaka Brian Justin · The Villages, FLN24313Wings Over Texas Holdings LLC · Denton, TXN24315Cubicle Concepts Inc · New Holland, PAN2431ESpartan College Of Aeronautics And Technology · Broomfield, CON2431LMarsh John E · Washington, DCN2431SDavis Girls LLC · San Jose, CAN2431UJackson Robert W · Bridgeport, TXN2431YBennett Mark · Normangee, TXN24327Centurion Aviation · Salina, KSFirst renewal noticeN2432CFreed Richard H · Watervliet, MIN2432QJohnson Carl H · Northstreet, MIN2432RLindsley Daniel · Vulcan, MIN2432SKraemer Richard A · Hollywood, FLN2432XVickers Ryan P Trustee · Tarpon Springs, FLN24331Registration Pending · Norman, OKRegistration pendingN24333Silver Express Co DBA · Miami, FLN2433DDh Communications Inc · Blairsville, GAN2433GHunt George P · Kamiah, IDN2433RRohrer Walter J · Gallatin, TNN2433YWheeler Dean S · Lebanon, OR
Back to AD 97-01-13