AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N21AWMershon James W · Newcomerstown, OHN21BVWright Gary N · North Fort Myers, FLFirst renewal noticeN21CFSmith Robert R · Benton, LAN21CMTj Air Holdings Inc Trustee · Wilmington, DEN21DBits Real Estate LLC · Foster City, CAN21DPPacific Fleet Aviation LLC · Rochester, NYN21DVHill Jack C · Arnold, MOFirst renewal noticeN21EXJones Thomas E · Crestline, CAN21FWilson Christopher J · W Hartford, CTN21FANikodem James · Crystal Lake, ILN21FDAldrich Jacob · Statesville, NCN21GLBuntings Grassroots Aviation LLC · Selbyville, DEN21HGDrisco LLC · Ponca City, OKN21HLChieftain Aviation Inc · Marietta, GAN21HUSkyline Aviation LLC · Lewistown, MTN21HYHunkus Kenneth F · San Angelo, TXN21JJWachtel Michael · Holly Springs, NCN21JKKaminski Charles D · Lancaster, CAN21JVMatula John K · Carlsbad, CAN21KMEmbrey Gary L · Georgetown, OHN21LKDalton Versel Jr · Fort Myers, FLN21MHKannapell Joseph H · Green Cove Springs, FLN21MVVollman Merlin · Pearland, TXN21NABeck Donald R · Lakeland, TNN21NCBearing Tree Land Surveying LLC · Oklahoma City, OKN21NFRegistered aircraftN21PLYankee Flying Club Inc · Maple Grove, MNN21PSStratman Paul · Kansas City, MON21PZEarl'S Spray Service Inc · Breckenridge, MIN21QTHarper Ken C · Kenai, AKN21RSRainier Air Inc · Wauna, WAN21TAerostar Marketing Group LLC · Nicholasville, KYN21TFFirdaus Tahir · Girard, OHN21TRCareer Aviation Company Inc · Wilmington, DEN21VGHarris Kenneth L · Greeley, CON21VTCle Aviation LLC · Palm Beach Gardens, FLN21WCAquino Richard J · Westfield, INN21WDMullens Aviation LLC · Estero, FLN21WKKing Wesley A · Los Angeles, CAN21WVHowell Jeffrey · Tehachapi, CAN21WYRegistered aircraftN21XGPrivitt Bret · Hudson Oaks, TXN21XLMilligan Edward · Beaverton, ORN2200JOld Prairie Products Inc · Angola, INN2200SPa32 Aviation LLC · Blue Bell, PAN2200YBarber Aviation LLC · Wilmington, DEN2201AJulius Air LLC · Lewes, DEN2201MSteck Richard E · Arlington Heights, ILN2201PRm Stoudt Inc · Jamestown, NDN2201QBocaj Air LLC · Irving, TX
Back to AD 2006-10-21