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.
N79463Riley Richard G Jr · New Brighton, PAN79467Horschel Duane D · Springville, NYN79468Whitmire Alan K · Canyon Lake, TXN7946BBrock Raymond Richard · Crescent, IAN7946FPaul Paulson A · Kipnuk, AKN7946GRegistration Pending · Beach City, TXRegistration pendingN7946TWright Anthony · Tallahassee, FLN7946UUpper Aircraft International LLC · Titusville, FLN79472Frey Michael L III · Waco, TXN79473Tnw Aviation LLC · Clinton, ARN79475Registered aircraftN79477Shipley David L · Yates City, ILN79478Fusano Lisa A · La Crescenta, CAN79479Larue Mark C · Leander, TXN7947BJames Bobby F · Bloomfield, INN7947GStearman Field Aircraft Repair LLC · Benton, KSN7947THarris Billy M · Waco, TXN7947ZBouchard Jamie Claude · Berwick, MEN79482Matacotta Ernest A · Marietta, GAN79488Nevels Steven D · Merritt Island, FLN79489Maisonet Gonzalez Hector W · Ocala, FLN7948BGruber Barbara L · Centreville, VAN7948TJolley Jonas D · Woodstock, GAN7948ZRlh Montana LLC · Helena, MTN79493Bounds Trucking LLC · Faison, NCN79498Gord James F · Sandwich, ILN79499Johnson Benjamin M · Monroe, WIN7949BHeffron Jacob L · Little Falls, MNN7949EPurstell Kevin · Burnt Hills, NYN7949FMaciol Michael W M D · Pelham, NYN7949TMacleod Brian D · Maumee, OHN7949ZFlores Carah L · Perris, CAN794CACivil Air Patrol · Maxwell Afb, ALN794CTCarolina Custom Farm Equipment LLC · Wilson, NCN794FAAb Prop Plane II LLC · Metairie, LAN794RGFb Aviation LLC · Minot, MEN79501Skyhawk Flying Club Inc · Omaha, NEN79506Allen Michelle E · Sebastopol, CAN7950BBobka Christian · Apple Valley, MNN7950EGanskop Brandy D · Flaxton, NDN7950GRotormate LLC · Royse City, TXN7950TSchroeder Henry G · Lacombe, LAN7950UBowden James E Jr · Eufaula, ALN79513Kalman Engineering Inc · Pekin, ILN79514Galaxy Aviation LLC · Nantucket, MAN7951BRocky Creek Jbd Inc · Boca Grande, FLN7951TClair Brent A · Loraine, ILN7951URegistration Pending · New Smyrna Beach, FLRegistration pendingN79522729 Air LLC · Las Vegas, NVN79526Evink Bradley D · North Branch, MN
Back to AD 79-10-14 R1