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.
N3176YThomas Steven Dale · Monticello, ILN3177Duvall John M III · Cincinnati, OHN3177CRsb Properties LLC · Lewes, DEN3177JDouble Rr Holdings LLC · Dallas, TXN3177SFreeman William R · Lenexa, KSN3177TCain James W · Big Rapids, MIN3177VSmith Daniel P · St George, UTN3177XBandy Suzanne M · Newport, ORN3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeN3178DSager Kenneth A · Hummelstown, PAN3178JBirmingham Pilot Academy LLC · Birmingham, ALN3178TAdvantage Aviation Services LLC · South Saint Paul, MNN3178YNiles Air LLC · Concord, NCN3179CWoods Kevin M · Spokane, WAN3179DPreiss James M Trustee · Poplar Grove, ILN3179FMoran Peter J · Como, MSN3179JTri-County Flyers LLC · Morgantown, PAN3179YWolstein Joe M · Bigfork, MTN317ACChickenhawk Inc · Wilmington, MAN317GTKatz Gary G · Louisville, KYN317KAWycka Michelle Sarah · Stayton, ORN317MZValiair Lc Trustee · Casper, WYN318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeN31803Mekker Mark S · Getzville, NYN3180DKleimer Steve · Bozeman, MTN3180QA & L Aircraft Holding LLC · Miami Springs, FLN3180RThomas Lance E Trustee · Mesa, AZN3180UBasan Oasis LLC · Santa Teresa, NMN3180YWalker Jim · Lovell, WYN3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeN3181SWood David M · Purcellville, VAN3181TDuck Donald S · Edwardsburg, MIN3181XHart George · Roseville, CAN3182DHanft Thomas A · Oakhurst, CAN3182QMagnusson Ralph L · Wyoming, MNN3182RSeven Hills Sky Divers Inc · Madison, WIN3182SRyan Aviation Management LLC · Palm Coast, FLN3182UGarcia-Martinez Jose Victor · Birmingham, ALN3182XHerrera Lizann · Sumner, WAN3182YHeckethorn Philipp · Baker, NVN3183CWide Open Aviation LLC · Kennewick, WAN3183DT2k Aircraft · Austin, TXN3183JRank Brian Andrew · Oxford, MIN3183QMj Syndicate LLC · Vancouver, WAN3183RRusso Anthony G · Melbourne Beach, FLN3183SJohnson Richard · Winnebago, MNN3183XTrimble John Sr · Stone Mountain, GAN3183YAlc Aviation LLC · Milwaukee, WIN3184DRitchie Rex W · Lopez Island, WAN3184QBeaugh Anthony H · Platteville, CO
Back to AD 97-01-13