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.
N7218ERice Ross H · Moab, UTN7218MFord Ethan G · Anchorage, AKN7218TTwilley Reginald M · Mobile, ALFirst renewal noticeN72194Skydive Ky LLC · Cecilia, KYN7219MBrincefield Leland L · Waconia, MNN7219STulsa Flight Training LLC · Bixby, OKN7219TScott Gregory R · Kennesaw, GAN721AEmbry-Riddle Aeronautical University · Daytona Beach, FLN721AAGammage Linda L · Delanco, NJN721CTChristiansen Aviation LLC · Wilmington, DEN721CWFischer Alfred M DBA · Genoa City, WIN721EREmbry-Riddle Aeronautical University Inc · Prescott, AZN721JMWalton Frederick W · Upper Sandusky, OHN721LULiberty University · Lynchburg, VAN721MWelch James D · Holdenville, OKN721NRUS Department Of The Interior · Boise, IDN721SACommonwealth Of Massachusetts · Bridgewater, MAN721SGAlaska Air Service LLC · Brookings, ORN721THAtp Aircraft 7 LLC · Wilmington, DEN721ZASky-Vu Flyers Inc · Fishers, INN7220GStagg Travis M · Fairbanks, AKN7220NNatural Selection Farms Inc · Sunnyside, WAN7221EMuller Farm And Ranch · Grenora, NDN7221MStartin Evan A · Colfax, WAN7221QSleeping Giant Flying Club · Helena, MTN7221SGardner Riley F · Hamilton, TXN7221TDahle Neil E · Mason City, IAN72222Jouppi Kenneth J · Ward Cove, AKN7222AChamberlain C Douglas · Bellefontaine, OHN7222NN B Tweet & Sons · Nome, AKN7222QMohawk Flying Club Inc · Ada, MIN7222TRegistration Pending · Lawndale, CARegistration pendingN7223ASather Evan · Hayward, CAN7223GLaze Daniel · Carson City, MIN7223MMoosehead Enterprises LLC · Estero, FLN7223NLee Stephen J · Cadiz, KYN7223QBuiqui Aerospace Corp · Kissimmee, FLN7223SSong David D · Ashland, CAN7223TRoberts Michael R · Plano, TXN7224EHowenstein John G · Roseville, CAN7224NCook Jon I · Cloudcroft, NMN72250Anderson Gilbert Lc · Palm Bay, FLN7225AFouts Philip W · Caldwell, IDN7225GVance Wilbur H III · Hershey, PAN7225SAero States Aviation LLC · Owasso, OKN7225VConnecticut Aircraft Sales LLC · Manchester, CTN7226EKinnebrew John · Adkins, TXN7226GHerlihy Douglas K II · Denville, NJN7226SN46132 Leasing LLC · Kalispell, MTN7226TCreasman Zane V · Arden, NC
Back to AD 79-10-14 R1