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.
N7940BHerbert Khristopher L · Tulsa, OKN7940EAircraft Guaranty Corp Trustee · Oklahoma City, OKN7940FMile High Flight Club Inc · Miami, FLN79410N79410 LLC · Tupelo, MSN79412Talley William B · Bakersfield, MON79416Greene Tammy G · Alpharetta, GAN79417Lhotka Tim · Silver Lake, MNN79418Lee Steven W · Somerset, KYN7941BTetrahedron LLC · Layton, UTN7941FLewis William J · Nashville, TNN7941GPressley Aviation LLC · New London, NCN7941TGoerger Allan E · Barney, NDN7941XDixie Aerial Surveillance & Photography LLC · Heflin, LAN7941ZThiel David W · Independence, ORFirst renewal noticeN79420Bas Part Sales LLC · Greeley, CON79421Kauer Roy A · Millington, MIN79424Mccutchan Anthony L · Collinsville, OKN79425Legends Airways LLC · Lakeland, FLN79428Mindset Dynamics LLC · Las Vegas, NVN79429Hinds Community College · Bolton, MSN7942BPuckett Jeffrey F · Rector, ARN7942GFlycarolina LLC · Rock Hill, SCN7942TLinebaugh Ricky L · Dover, PAN7942VKing Air Inc · Naknek, AKN7942ZBrown David L · Hughesville, MON79431Brown Joshua W · Pomona, ILN79432N7037g Inc · Wilmington, DEN79434Gilpin Jeffrey · Portland, ORN79435Pearce Gregory W · Eagle River, AKN79436Granskog Gary L · Chico, CAN79439Asm Aviators LLC · Racine, WIN7943BMoul Dale E · Boise, IDN7943EQuisenberry Richard S · Marietta, OKN7943FRegistered aircraftN7943ZAlrubaiie Ihssan Robert · Fort Worth, TXN79440Spatiumtech LLC · Madison, ALN79442Friedmann David · San Diego, CAN79445Raniolo James · Jackson, WYN79447Aroostook Aviation LLC · Millinocket, MEN79448Thomas William B · Converse, LAN7944BHarms Steven Lee · Cedar Rapids, IAN7944FBrown R Ed · Vandalia, ILN7944GBogardus Peter S · Gouverneur, NYN7944ZFreeman J · Memphis, TNN79450Smith Jeff C · Cincinnati, OHN79453Zimmer James E · Corning, CAN79454Gavranovic Willie · Wharton, TXN79459Resort Region Flying Club LLC · Kalispell, MTN7945GWinger Matthew · Vail, AZN7945VN7945v LLC · Wilmington, DE
Back to AD 79-10-14 R1