AD 47-06-01
Registered aircraft · 541
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:47-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-06-01')
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:47-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-06-01') 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.
N2373BWarbird Adventures Inc · Ocoee, FLN2374BBoard David N · Moundsville, WVN2379BRegistered aircraftN2383BArt-Ticulate Tees LLC · Hazard, KYN2384BAuiler Casey · San Diego, CAN2385BHernandez Dominic Juan · Brighton, CON2387BMacken Inc Corp · Saint Paul, MNN2390BSwift Museum Foundation Inc · Athens, TNN2394BSackett Dennis M · Orangevale, CAN2397BCochran Keith · Long Beach, CAN2398BCross John P · Houston, TXN2399BSummerland Spins LLC · Summerland Key, FLN2402BDaulton Rodney D · New Port Richey, FLN2403BDmm Airshows LLC · Wilmington, DEN2404BHaugen Michael · Oklahoma City, OKN2410BMiller Charles T · Bynum, TXN2413BLohse Randy · Onalaska, WAN2418BBartholomew Don B · Gardnerville, NVN2419BFenn Michael J · Cloverdale, CAN2422BRoki Classics LLC · Ogallala, NEN2428BZahler Mitchell J · Stillwater, MNN2429BRegistration Pending · Oshkosh, WIRegistration pendingN2431BSampson Joel L · Belview, MNN2432BKuffel Florian L · Seattle, WAN2436BDahler George F · Monterey, CAN2437BHernandez Dominic J · Brighton, CON2438BJentes Charles A · Smithville, OHN2440BBrubaker Farm Company Inc · Traer, IAN2441BNaumann Scott Trustee · Arroyo Grande, CAN2442BSwifty LLC · Dover, DEN2443BBartholomew Don · Gardnerville, NVN2444BRubiano Anthony · Cheyenne, WYN2446BHolliday Mark E · Lake Elmo, MNN2449BHolliday Mark E · Lake Elmo, MNN2451BSimply Living LLC · Fort Myers, FLFirst renewal noticeN2453BWalker Ray · Sanger, TXN2455BGillaspie Wade · Huntsville, TXN2457BGurel Samuel E · Bentonville, ARN2460BSwift Museum Foundation Inc · Athens, TNN24SEBertus David · Coppell, TXN251DTSwift Action LLC · Akron, OHN266JTCochran Keith W · Long Beach, CAN280VFKaczmarek Richard G · Sandersville, GAN28AGZahler Mitchell J · Stillwater, MNN2LMCollins Cody W · Palestine, TXN30JWLittle Colin J · Bidwell, OHN31WAbell Alan R · Elgin, ILN3200KRock Jeffrey B · Fountain Valley, CAN3202KKennelly Kevin T · Fort Lupton, CON3207KHull Bart D · Laveen, AZ
Back to AD 47-06-01