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.
N21145Regal Equipment LLC · Coarsegold, CAN21146Metzger Leesa A · Claypool, INN21148Christoph Ryan M · Omak, WAN2114GMission Aviation Fellowship · Nampa, IDN2114SCochise Community College · Douglas, AZN2114XGsi Corp · Eastham, MAN21150Smith Timothy L Trustee · Gig Harbor, WAN21157Beta Fleet LLC · South Burlington, VTN21158Cbkg Holdings LLC · Chelsea, ALN21159Kope Gregory A · Leesburg, VAN2115GBroeske Ian D · Windsor, CAN2115MRedman Company LLC · Troy, MIN2115YDavis Rodney E · Nanty Glo, PAN21162Walton Jack W · Willcox, AZN21163Jet Mic LLC · Blossom, TXN2116RS&H Aviation LLC · Myrtle, MSN21171Maggio Joseph · Sparta, NJN21172Jk Aviation LLC · Sioux City, IAN21174Registration Pending · Atlantic Beach, FLRegistration pendingN21176Gades Gary A · Montevideo, MNN21177Valiair Lc Trustee · Casper, WYN21178Park Rodney D · Boring, ORN21179Blakey Tammy S · Arlington, WAN2117FHelms Stephen · Anchorage, AKN2117QGately Brian · Brooklyn, NYN2117RAlt Oliver B · Newberry, FLN2117ZDe Schweinitz Christian R · Anchorage, AKN21181Chef Force One Aviation LLC · Miami Beach, FLN21184N21184 LLC · Monticello, MNN21189Axxo LLC · Flagstaff, AZN2118GKohlhase Amy M · Anchorage, AKN2118RKopecki Carin E · Hobson, TXFirst renewal noticeN2118YS&G Enterprise Inc · Owensville, INN21191Schrott Bradley S · Federal Way, WAN21192Aaa Auto Salvage Inc · High Point, NCN21193Krueger Scott M · Salem, SCN21196Ashurst Richard J · Westmorland, CAN21199Shaw Deane F · Centerville, MAN2119GReese Gerald D · Brooten, MNN2119RAviation Boosters Inc · Sparta, NJN211AJLevisee Steve · Irvine, CAN211ANCalifornia In Nice Inc · San Jose, CAN211ASBas Part Sales LLC · Greeley, CON211ATGeorge'S Aerial Spraying Service Inc · Sutton, NEN211AVN8191e LLC · Manassas, VAN211BAWojteczko Jason A · Derby, KSN211DXHalter Dudley M · Locust Grove, GAN211EWJtb Logistics LLC · Byars, OKN211HPN211hp LLC · Lantana, FLN211KCPau Hana LLC · Wilmington, DE
Back to AD 97-01-13