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.
N79074Arrol Keith C · Fairfield, CAN79079Jones Farm Fresh LLC · Bartlett, TNN7907TKdrd Holdings LLC · Texas City, TXN7907UReifenberger Robert A · Saint Petersburg, FLN79080Snider Roger A · Harlem, MTN79081James Ferrick · Mechanicville, NYN79086Marshall County Flying Club Inc · Lacon, ILN79087Air Discovery La LLC · North Hollywood, CAN79089Ramaswamy Gautam · Clearwater, FLN7908BFrancis James E · King City, CAN7908GChamberlain Bruce H · Worcester, MAN7908TGausman Ryan O · Thorp, WAN7908UBrogan Scott D · Bellevue, OHN7908ZOnyx Performance Aviation LLC · Bakersfield, CAN79090Caughman John R · Katy, TXN79092Aero Quest LLC DBA · Olive Branch, MSN79093Bray Austin M · Pontotoc, MSN79095Hole In The Clouds Rentals LLC · Montgomery, ALN7909ENeiggemann Patrick B · Ventura, CAN7909FK-Air Inc · Egg Harbor, WIN7909GCopass Kaneia · Fountain Run, KYN7909NUnited States Air Force Owner · Colorado Springs, CON7909XEisenhauer Lyle M · Sterling, NEN790FAAb Prop Plane II LLC · Metairie, LAN790SATavern Aviation LLC · Tavernier, FLN790SPMustang Sally Aviation LLC · Camden, SCN79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHN79104Roman Nose Flying Club Inc · Newalla, OKN79105Linn Nicholas D · Norfolk, NEN79107Rosequist Christopher Conrad Trustee · Moyie Springs, IDN7910BJohnson John A Trustee · Sandy, ORN7910EBobbitt Charles W · Madill, OKFirst renewal noticeN7910GBrusse Leslie W · Enterprise, ALN7910UStechschulte Jason P · Fort Jennings, OHN7910VReifel Christopher · Eagle River, AKN7910ZCooper Jeffrey S · Honeoye Falls, NYN79113Executive Flight Institute LLC · Murrieta, CAN79118Osceola Aerosport LLC · Osceola, WIN79119Carr Randal J · Chandler, OKN7911BDaugherty Monte R · Anderson, INN7911VBig Bend Community College · Moses Lake, WAN7911XRice David L · Dickson, TNN79122Johnson John C · Squaw Valley, CAN79125Brekhus Palmer A · Tolley, NDN79126Grounded Hangar Inc · Turlock, CAN79128Hawkins Jeffery D · Mandeville, LAN7912ECallahan Richard T · Lancaster, CAN7912USweet Breeze Aviation LLC · Gordonsville, VAN7912XWang Jinrao · Riverdale, GAN79130M&M Shipshape LLC · Kalispell, MT
Back to AD 79-10-14 R1