AD 2011-01-52
Registered aircraft · 416
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:2011-01-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52')
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:2011-01-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52') 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.
N53KFHaynes Robert Kent · Pilot Point, TXN556BKd Helicopters Inc · Shingleton, MIN557DCJoslyn Larry J · Las Vegas, NVN5594YWdw Aviation Leasing Inc · Knoxville, TNN55PHElectrical Design Consultants Group LLC · Pepper Pike, OHN58160Brb Flight Services LLC · Laguna Beach, CAN58174Castle Farms Inc · Sunnyside, WAN58206Kiwi Choppers LLC · Hillsboro, ORN58208Smith Helicopter Inc · Cotulla, TXN58281Lueck Thomas J · Cedar Rapids, IAN58319Schweizer Rsg LLC · Fort Worth, TXN58344Wolff Scott A · Missoula, MTN58359Warner Robert G Jr · Broomall, PAN58363Hartle Aaron Duane · Vicksburg, MIN58371Bilton Aircraft Management Inc · Umatilla, FLN58384Sonnichsen Landen D · Delta Junction, AKN58397Frost Darrell G · Atlanta, TXN6120ABrabeck Mark F · Glasgow, MTN6126TGuida Associates Consulting Inc · Sandpoint, IDN6128UJoslyn Larry J · Las Vegas, NVN6136KAll On Black LLC · Mount Nebo, WVN61447Overton Tommy · Cumberland Gap, TNN6144VAir Flite Inc · Shawnee, OKN61458Dls Holdings Inc · Lewes, DEN6145VMarshall University · Huntington, WVN6147EBuckley Michael J · Billings, MTN61486Johnson Gary R · Carthage, NYN6148VChupp Aaron · Gallipolis, OHN614TVDurmisevich Dean J · Carnation, WAN6163EPrice Keith E · Ossian, INN61MJSnell Matthew Lea · Ackerly, TXN62269Ashcraft Matthew · Abbott, TXN62273Mundell Terry Trustee · Rosston, OKN62293Bilsky William E · Titusville, FLN6258BA&A Conveyor And Equipement Inc · Pennington Gap, VAN626LHHeli-Tech Inc · Panama City, FLFirst renewal noticeN637WSGulf Coast Helicopters Inc · Pearland, TXN645KAHelocraft Holding Co Inc · Pembroke Pines, FLN64732A And J Aviation Services LLC · Okeechobee, FLN653CHKelley Aviation Consultants LLC · S Williamsport, PAN656RBBas Part Sales LLC · Greeley, CON662RSBender Jeff L · Canal Winchester, OHN67TKBuckley Michael J · Billings, MTN691RRAnderson Stuart R Jr · Sahuarita, AZN699LCAero Management LLC · Austin, TXN7032ZJones James William III · Lebanon, VAN7050DFoster David S · Justin, TXN7057LTri County Rentals And Sales Inc · Chiefland, FLN705RMReynolds Darryl G · Wills Point, TXN711CHYoung Vernon P · Metter, GA
Back to AD 2011-01-52