AD 2015-20-13
Registered aircraft · 5,444
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:2015-20-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-20-13')
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:2015-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-20-13') 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.
N2052MDehnel Kris P · Cedar Park, TXN2054MMcdonald Patrick R · Waverly Township, PAN2055MHarding Lawrence · Santa Monica, CAN205FAStratus Rr LLC · New Castle, DEN205THAaces Flight Operations LLC · Ellisville, MON205ZAlpha Tango Aircraft LLC · Wilmington, DEN2069MSeton Perry · Casper, WYN2070MD&L Aviations LLC · Breckenridge, TXN2071MBudd Aircraft Enterprises Inc · Chesterfield, MON2073MHanel David Matthew · Suwanee, GAN20784Dbab LLC · Belleville, ILN2078ARyan John T · Salina, KSN207ABCoco Aircraft Inc · Merritt Island, FLN207CBCalifornia Baptist University · Riverside, CAN207ESPiper Aircraft Inc · Vero Beach, FLN2080VMcguire Rental Properties LLC · Prescott, ARN2081CPray Aviation Inc · Augusta, KSN2085VForbes Aviation LLC · Boise, IDN20864Dishart Bradley E · Gibsonia, PAN20873Mang Aero Club · Belleville, MIN2087NRls Rental Co DBA · Joplin, MON2088AGary Jet Center · Gary, INN2088BGeneral Aviation Support Corp · Rosamond, CAN2088DNationwide Aviation LLC · Hudson Oaks, TXN2089NSchroeder Reinhard · Poulsbo, WAN208GGPenn Yan Flying Club Inc · Penn Yan, NYN2090VWater Sports Unlimited · Griffin, GAN2091BRegistered aircraftN2091DRegistration Pending · Magnolia, TXRegistration pendingN2091MGreat Planes Aviation Inc · Rochester, MNN2092AKimmons Anthony J · Quitman, TXN2092MRegistration Pending · Augusta, KSRegistration pendingN2092XAirx LLC · Warwick, RIN2093MAir Cortright LLC · Boyne City, MIN20958Ras Aviation LLC · Elyria, OHN2096LMcfarland Bruce R · Newberry, FLN2097MDm Asset Management LLC · Plain City, OHN2097NSidney Flying Club Inc · Sidney, OHN2097UNorris Barry D · Soquel, CAN20985Aero X Flying Club Inc · Winchester, VAN2099Paragon Airplane Leasing Co · Fort Myers, FLN20992Sketo Aviation LLC · Bardstown, KYN209JRegistered aircraftN20GGHofer Danny C · Huron, SDN20LLFlying 20 Club Inc · Springfield, ILN20QCHenderson Stephen L · Carthage, NCN20SALc Air Leasing LLC · Treasure Island, FLN20TACopperstone Fc LLC · Lancaster, PAN2102CGreat Northern Aircraft Inc · Griffith, INN21030Aircraft Management Group Inc · Honolulu, HI
Back to AD 2015-20-13