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.
N2134JMcmahan Michael Anthony · Dunwoody, GAN2135BMiloud Chadd K · Fort Worth, TXN2135FMark Alan Bennett · Trinidad, CON2136JHanus John E · North Kingstown, RIN2136MWashington Israel · Cincinnati, OHN2136YW Tech Consulting Inc · Wilmington, DEN2137JAdverse Yaw LLC · Milford, CTN2139JHotung Lisa M · Amherst, NYN213BPJim Nichols Air Service LLC · Fincastle, VAN2140VSidhu Harish · Anaheim, CAN2140YNorcal Flight Club · Vacaville, CAN21411Piper Partners · Coventry, CTN21412Long Island Aviators LLC · Seaford, NYN2141JRegistered aircraftN2141RM5:16 Ventures LLC · Brush Prairie, WAN2143YBk Aviation Services LLC · Graford, TXN21441Paris Air Inc · Vero Beach, FLN21442Ducote Randal J · Parker, CON21443Compton James R · Boise, IDN2144WHansen Kenneth L · Kimballton, IAN2145MHanscom Afb Aero Club · Hanscom Afb, MAN2147GAviation Capital Management LLC · San Jose, CAN21481Houston Christopher T · Webster, NYN21489D & S Aviation LLC · Spring, TXN2148ZMalburg Phillip E · Holland, MIN2149ZBauer Jeff C · North Falmouth, MAN214RAJw Aero Holdings Inc · Canandaigua, NYN2150FShoreline Aviation Inc · Marshfield, MAN2150YGoldstein Orpaz · Woodland Hills, CAN2150ZHilton Head Flyers LLC · Liberty, SCN21522Hove Paul · St Paul, MNN2152AWojtowicz Jacek A · Rhinebeck, NYN2152ZN2152z LLC · Middletown, DEN2154FGentile Nicholas J · Spring Grove, PAN2157BMesheryakov Roman · Jacksonville, FLN2157YRegistration Pending · Northampton, MARegistration pendingN2158ZTribute Aero LLC · Rochester, MIN2159HBeverly Flight Center LLC · Middleton, MAN2159QWisconsin Aviation-Four Lakes Inc · Madison, WIN215UParagon Airplane Leasing Co · Fort Myers, FLN215ZAlpha Tango Aircraft LLC · Wilmington, DEN21605Chandler Air Service Inc · Chandler, AZN2163GWilson Willard III · Cannon Falls, MNN2164GAulton New Energy Inc · Monterey, CAN2165BCondor LLC · Cumberland, RIN2165HQuin Air Inc · Shreveport, LAN2166BScroggs Ross A · Locust Grove, GAN2166FUniversity Of Oklahoma · Norman, OKN2166LNefc Inc · North Andover, MAN2169FBrolan Aviation LLC · Kansas City, MO
Back to AD 2015-20-13