AD 2011-06-02
Registered aircraft · 16,140
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-06-02')
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-06-02')
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-06-02') 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-06-02') 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.
N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTN103KSKent State University · Stow, OHN103LULynn University Inc · Boca Raton, FLN103SVSun Valley Aviation Inc · Harlingen, TXN103VKCc Aviation Inc · Tracy, CAN1041SN1041s LLC · Key West, FLN1042SPiper Cameron · Winchester, VAN1043SAmerican Aviator LLC · Newark, DEN10446Schell Brothers II LLC · Rehoboth Beach, DEN104EDEdwards Aero Club · Edwards Afb, CAN104FSGibson Aviation Services LLC · Menomonie, WIN104JBF2 Aviation & Marine Assets LLC · Solana Beach, CAN104LULynn University Inc · Boca Raton, FLN104NPDv Aviation Inc · Brainerd, MNN104PDBaumann James R · Muskogee, OKN104PFLewis University · Romeoville, ILN1053XChristiansen Aviation LLC · Wilmington, DEN1057FBoldflight LLC · Bargersville, INN1057RAnesthesia Aviation LLC · Leesburg, VAN105AGAtp Aircraft 1 LLC · Wilmington, DEN105EDEdwards Aero Club · Edwards Afb, CAN105HFHeritage Asset Leasing LLC · Ronkonkoma, NYN105JKSky West Aviation Inc Trustee · Albuquerque, NMN105LULynn University · Boca Raton, FLN105PDN105pd LLC · Ulysses, KSN105RDSunny Slope Aviation LLC · Adams, TNN1061XMelbourne Flight Training LLC · Melbourne, FLN10624Daytona Aircraft Leasing LLC · Daytona Beach, FLN10632Skyblue Aviation Cr Inc · Merritt Island, FLN1068FDubois Marcus S · Olive Branch, MSN1068MWolfenden Allen K · Rocklin, CAN106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLN106EDEdwards Aero Club · Edwards Afb, CAN106ESOliverson Lee Ann N · Sandy, UTN106ETFairmont State University · Fairmont, WVN106GCJones Michael D · Warner Robins, GAN106GTGendron Paul F · Vero Beach, FLN106NKMenagerie Enterprises Inc DBA · Denison, TXN106RAChristiansen Aviation LLC · Wilmington, DEN106VKLumion Aviation LLC · Mountain View, CAN1071Z5280 Flying Club LLC · Castle Pines, CON1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLN1074TIowa Lakes Community College · Estherville, IAN1078MGeorge Gary D · Humble, TXN1079MGeneral Aviation LLC · Henderson, NVN107AFKummer Michael · Floyd'S Knobs, INN107ALAero Tech Services Inc · Lititz, PAN107BAFairmont State University · Fairmont, WVN107CGColon Orlando · San Juan, PRN107ELAa-Aero LLC · Lewes, DE
Back to AD 2011-06-02