AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N6386FRasys Paul J · Lawton, OKN6386GSonafrank Eric · Somerset, INN6386VSaunders Andreas · Wake Forest, NCN6387FMitich Nathan · Fort Worth, TXN6388DBdo Aviation LLC · Dallas, TXN6388GGaller Frank G · Elysian, MNN6388YMaclean Kenneth J · Northborough, MAN6389FSymms Fruit Ranch Inc · Caldwell, IDN6389GHagen Alfred · Bensalem, PAN638AGSkywest Leasing Inc · St George, UTN638CPCivil Air Patrol · Maxwell Afb, ALN638CTCoast Flight Training And Management Inc · San Diego, CAN6390BPalmer Bryce P · Chugiak, AKN6390ERyan Michael P · Melrose, IAFirst renewal noticeN6390SStraub Aircraft Holdings LLC · Overland Park, KSN63918Sky Warrior Flight Training Inc · Pensacola, FLN6391EDay Stephen F · Queen Creek, AZN6391JAty Aviation Inc · Watertown, SDN6391UGimli Son LLC · Fort Lauderdale, FLN63921Nc Division Of Marine Fisheries · Morehead City, NCN6392ARlf Aviation LLC · Peachtree Corners, GAN6392BHubatka Wilferd · Creston, IAFirst renewal noticeN6392CTretter Nicholas · Holden, MAN6392EWinds Aloft Inc · Lakeland, FLN6392GJtw Aero Leasing LLC · Frederick, MDN6392YBoldflight LLC · Greenwood, INN6392ZFlorence Michael · Portsmouth, NHN6393ALadmill Investments LLC · Gulfport, MSN6393BLebard Racquele J · Sparks, NVN6393EBrewster Richard D · Bellvue, CON6393GKrusell Robert S · Blairsville, GAN6393RGilbert John · Austin, TXN6394BPepitone David D · Santa Fe, NMN6394DManzur Miguel Antonio · Mcallen, TXN6394EMilco Airways Inc · River Hills, WIN6394FScowden Wendell R · Piketon, OHN6394SLincoln Air LLC · Kalispell, MTN6394VRice Aviation · Maddock, NDN63958Christiansen Aviation LLC · Wilmington, DEN6395ARose City Soaring Association Inc · Valdosta, GAN6395BMb Laster Aviation LLC · Eagle, CON6395DBirks Jeffrey R · Nokesville, VAN6395EStott David L · Wasilla, AKN6395FSalisbury Neilan · Trabuco Canyon, CAN6395ZN Berk Consultant Inc · Greenwich, CTN6396BGeezer Guys LLC · Eloy, AZN6396DOc Flight Lessons LLC · Costa Mesa, CAN6396ELecrone Craig W · Duncansville, PAN6396FKing Emily · Laramie, WYN6397BLayson Walter E · Calhoun, GA
Back to AD 79-10-14 R1