AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N1235HTravis Michael D · Anchorage, AKN1235KWheeler Brian K · Landenberg, PAN1236QRawareo LLC · Warsaw, MON1237EKing Bruce · El Paso, TXN1237QN37gd LLC · Fort Myers, FLN1237YLootens David P · Wofford Heights, CAN1238YGasman Aero LLC · Kalispell, MTN1239QFleishauer John · Trona, CAN123ACAerocareers Nfp · Columbia, ILN123BKBuscombe Stanley G · Sacramento, CAN123BWWiplinger Robert D · Inver Grove Hts, MNN123JMWood Chris A · Everett, WAN123MSSnyder Walt E · Laguna Niguel, CAN123PYDotson Daniel · Holly Springs, MSN123RWWiplinger Robert D · Inver Grove Hts, MNN123XLJohnsman Nathan R · Portland, INN1240DBaeder Mark A · Mesa, AZN1240HDestefano Patrick S · Bryan, TXN1240YChanter Connor N · Grayslake, ILN1241QFly Rite Aviation LLC · Fort Myers, FLN1242DPrice John C · Bennington, KSN1243WHelmer David R · Eagle, AKN1244DBackcountry Aviation LLC · Ankeny, IAN1245DChism Jerry · Austin, ARN1246YMacy G Kevin · Brownsville, CAN1247DWroe Daniel C · Denton, MDN1247YRogers Jacki-Lyn · Standish, MEN1248QHeffernan Kasey C · Torrance, CAN124DWGray Keoki P · Fernandina Beach, FLN124MPPierce Mark O · Kansas City, MON124QKepes Bruce R · So Charleston, OHN124VHGerhardt Byron S · Williamsport, OHN124WSLarson Thomas E · Fort Collins, CON1250DSmith Christopher R · Manvel, TXN1250QSantiago Luis R · Waller, TXN1251Miltz Karl W · Black River, MIN1251YDurden Julian F Jr · Twin City, GAN1252HPallasch Cooper William · Denton, TXN1253HTschepen Leo R · Bisbee, NDN1254QWeber Joel A · Goddard, KSN1255QDrucker Jonathan · Spring Hill, FLN1256DYoung Robert J · Conroe, TXN1256QRose Kerry D · Liberal, MON1257DKendrick Ross M · Sycamore, GAN1258DInternational Air Services Inc Trustee · Carson City, NVN1259HSibley Dean R · Arcadia, CAN1259QBuckles Ryan · Mont Belvieu, TXN125AWWaterwings Seaplanes LLC · Hoover, ALN1260YBoatright Michael L · Live Oak, FLN1261DEpstein Neal R · Medway, MA
Back to AD 94-05-05 R1