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.
N2225ZLukezic Bret · Longmeadow, MAN22262Oldenkamp David J · Payson, AZN22265Edb Air Inc · Wilsonville, ORN22266Oldenkamp David J · Payson, AZN2226DJenkins Danny W · Nebo, KYN2226NWingsleasing LLC · Wichita, KSN2226TRegistration Pending · Tucson, AZRegistration pending, pending cancellationN2227CCain Jeffrey B · Godley, TXN2227FBay Area Aviation LLC · Beach City, TXN2227HHillsboro Aero Academy LLC · Hillsboro, ORN2227JAldred John B · Washoe Valley, NVN2227RWilhite Randy J · Jackson, MIN2227XMoravec Jason A · Houston, TXN22281Boelke Christopher T · Starbuck, MNN2228THulsey Hunter · Madison, MSN2228ZThunderbird Aircraft Co · Bloomington, MNN22293Jacobson Duane A · Marco Island, FLN22295Poole Frederick J · Meridian, MSN2229JKaiser Hayward J · Los Angeles, CAN2229QM21 Aircraft Leasing LLC · Morganton, NCN2229UCalifornia In Nice Inc DBA · San Jose, CAN2229WCook Arlyn L · Alta Loma, CAN2229YWehkamp Air LLC · Ingalls, KSN2229ZGeorge Walker Field Inc DBA · Bedminster, NJN222ARBrowne Michael · Big Lake, TXN222AYCannoles Ronald · Las Vegas, NVN222BHLudwigson Joel R · Inver Grove, MNN222BWAuer William E · East Liverpool, OHN222DUCg 340 LLC · Fountain Hills, AZN222ECInternational Air Services Inc Trustee · Carson City, NVN222ESThakkar Ravi R · Charlotte, NCN222FGoddspeed LLC · Encinitas, CAN222GBJames David L DBA · Auburn, CAN222GDSolverson Aircraft Management LLC · Waunakee, WIN222GESmith Daniel J · Mcmurray, PAN222GFFischer Edward T · Appleton, WIN222GGLangley Richard A · Sheyenne, NDN222HLDouble K Flying LLC · Scottsboro, ALN222HMAmerican Saddlair LLC · Park City, UTN222HPHarrison Walter E · Taylor, TXN222HUPlane Nutz LLC · Sugar City, IDN222HYWarner Robins Air Service Inc · Cochran, GAN222JAJeff Abrams LLC · Ocala, FLN222JDAcro Aviation LLC · Littleton, CON222JGNoyes Jeffery A · Bridgeport, TXN222JLThomas Kent C · Muncie, INN222KHPavco Inc · Gig Harbor, WAN222KLLohmueller Kurt M · Powder Springs, GAN222KRSharon Carl G · Brookshire, TXN222KSTriple Two Inc · Wilmington, DE
Back to AD 2006-10-21