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.
N208SAL3harris Technologies Flight Capital LLC · Greenville, TXN208SMGrant Aviation Inc · Anchorage, AKN208SNStraight Flight Nevada Commercial Leasing LLC · Sparks, NVN208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTN208SVBank Of Utah Trustee · Salt Lake City, UTN208TCKissee Zachary Robert · Chugiak, AKN208TFMartinaire Aviation LLC · Addison, TXN208TMRedding Aero Enterprises Inc · Redding, CAN208TRSouth Aero Inc · Albuquerque, NMN208TWCaravan Air LLC · Oxford, CTN208UUSpeedstar Express LLC · Carson City, NVN208VBas Part Sales LLC · Greeley, CON208WSilver Mountain LLC · Port Alsworth, AKN208WBAlgot Bernhard Ltd · Anchorage, AKN208WFWipaire Inc · South Saint Paul, MNN208WPCassidy Ryan H · Seattle, WAN208WWWestwind Aero Group LLC · Phoenix, AZN208YYAircraft Structures International Corp · Enid, OKN208ZZSpeedstar Express LLC · Carson City, NVN20907Ward Roger L · Ghent, WVN2090GLight Chop LLC · Lexington Park, MDN2090QRawls Mike E · New Waverly, TXN2090XTreeline Services LLC · Grimes, IAN2090YKilbey Bryan E DBA · Defuniak Springs, FLN2090ZRegistered aircraftRegistration pendingN20914Jackson George F Jr · Saint Leonard, MDN2091QJohnson Earl V · Andalusia, ALN2091XBas Part Sales LLC · Greeley, CON2091YCut And Snip Flyers LLC · South Weber, UTN20920Berry Danny · Rusk, TXN20921Brigham David F · Elliottsville Twp, MEN20923Langford Thomas R Jr · Mount Clare, WVN20929Heinl Christopher · Hickory, NCN2092GUllrich Sandy J · Haskell, OKN2092YNiver Michael A · Plymouth, WIN20932Registration Pending · Hammond, LARegistration pendingN20934Fly Skyhawk Llp · Galena, OHN20935White Mark · Cadiz, KYN20936Nedbalek Brent · Brenham, TXN2093GNew Herschel Dudley Jr · Savannah, GAN2093YSale Reported · Agar, SDSale reportedN20940Cirrus Flight Operations Inc · Minneapolis, MNN20944Moody Robert L · Ava, MOFirst renewal noticeN20946Local News LLC · Janesville, WIN20948Wallin Rolf B · Fayetteville, NCN2094YHill Karl A · Visalia, CAN2094ZSpak Andrew T · Thousand Oaks, CAN20951Strevels Stephen M · Knoxville, TNN20954Hardin John M · Terrell, TXN20955Dimich Milan C · La Jolla, CA
Back to AD 97-01-13