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.
N1789Hill Sheldon S · Minot, NDFirst renewal noticeN1789CBuxton Tracy S · Enterprise, UTN1789MMjr Aviation Consultants LLC · Clearwater, FLN178DRH&H Trucking Inc · Clarkdale, AZN178EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN178FVD R Tripp Enterprises LLC · Omaha, NEN178KASwartzentruber Robert · Oakland, MDN178RSDowns Austin J DBA · Liberal, KSN178SKOppenheim Kyle A · Mountain View, CAN178VVStanley Bryan Dale · Paso Robles, CAN178ZLUsda Forest Service Fepp · Columbia, SCN1790FTaylor Henry F · Urbana, OHN1790RBlack Dog Holding Inc · Pleasant Valley, NYN1791ESol Aerial Surveys LLC · Las Vegas, NVN1791MA & S Helicopters Inc · Cahokia, ILN1791QNearpass Stephen J · Seneca Falls, NYN1791VOmargows Ali · Columbus, OHN1792REcho Matrix LLC · Bentonville, ARN1793QFreedom Aviation Inc · Lynchburg, VAN1793VAviation Capital Management LLC · San Jose, CAN1794CAcp Aviation LLC · Oakdale, LAN1794MSkyriders Flying Club Inc · Aurora, CON1794XGulf Atlantic Airways Inc · Gainesville, FLN1795CSchellhaas Bennett · Galloway, OHN1795ERb Aviation LLC · Tyler, TXN1795RBroussard Kenneth John · Lafayette, LAN1796GHorowitch Alan · San Diego, CAN1797CKelley Larry D · Portland, ORN1797MCp & R Transport LLC · Grace, IDN1797RNorthstar Holdings LLC · Anchorage, AKN1797XN1797x Aero LLC · Gulf Breeze, FLN1797ZReal Fly Air Service LLC · Jackson, WYN1798MWalker Steven C · Lake Havasu City, AZN1798RSedwick Jack D III · Anchorage, AKN1798XN1798x LLC · Etna Green, INN1799RAir Support 1 Inc · Middletown, DEN1799ZWanderlove Alaska LLC · Anchorage, AKN179DBBrisco Daniel J · Fort Myers, FLN179SAPriority Air Charter LLC · Kidron, OHN179WSEbken Gary R · Loxahatchee, FLN179WZCatterton Jane S · Signal Mountain, TNN179XPLadonne Frank · Fort Collins, CON17ABBas Part Sales LLC · Greeley, CON17AMFarmdog Aviation LLC · Lafayette, INN17BHFoster Brian J · Mancelona, MIN17BSSell William T · Orofino, IDN17CJ16d Aviation LLC · Vashon, WAN17CKAgape Flights Inc · Venice, FLN17CPN17cp Corp Trustee · Wilmington, DEN17DMLevin Jason Daniel · Aptos, CA
Back to AD 97-01-13