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.
N62350Flycarolina LLC · Concord, NCN62354Skywarrior Flight Training Inc · Pensacola, FLN6235AStewart Madison F Co Personal Representative · Broken Arrow, OKN6235ELee William Lewis · Gilbert, AZN6235KCall One Inc · Clarinda, IAN6235SRudnik Zachary A · Minto, NDN6235TCrystal Air Inc · Chattanooga, TNN6236MJlkd LLC · Lewes, DEN6237ESale Reported · Brandon, MSSale reportedN6237FPerea Joseph R · Albuquerque, NMN6237RBorden Jonathan Wilfred · Londonderry, NHN6237TReinhardt Larry L · Clackamas, ORN6237YStrategic Sourcing Solutions Inc · Topeka, KSN6238AExecutive Flight Institute LLC · Murrieta, CAN6238RRegistration Pending · Preston, IDRegistration pendingN6238TLocklear Benjamin M · Mangum, OKN6238UInland Crop Dusters Inc · Shafter, CAN6239APara Plane Aviation Inc · Thomasboro, ILN6239DAerial Precision LLC · Entiat, WAN6239EKnutson Wayne R · Thompson, NDFirst renewal noticeN6239FEckert Ted · Cedar Creek, TXN6239RBala Engineering Pllc · Hawkins, TXN6239TEvans Cliff D · Boulder Creek, CAN6239YBlue Horizon Aviation LLC · New Concord, OHN623APHartman Michael F · Montclair, CAN623DWHtft LLC · Las Vegas, NVN623EPApex Aviation LLC · Exeter, NHN623EREmbry-Riddle Aeronautical University Inc · Prescott, AZN623HBRidgeline Assets LLC · Wilmington, DEN623KWLanier Equipment Leasing LLC · Gainesville, GAN623RTTextron Aviation Inc · Wichita, KSN623SPAtp Aircraft 2 LLC · Wilmington, DEN623UTTextron Aviation Inc · Wichita, KSN623WTChasteen Tom · Tavernier, FLN62400Henline Matthew · Honolulu, HIN62405Flight School Of Gwinnett Inc · Lawrenceville, GAN62407Hillsboro Aero Academy LLC · Hillsboro, ORN6240BVan Treese Farms Inc · Monte Vista, CON6240EDgcg Properties LLC · Casa Grande, AZN6241AAerial Messages Leasing Co · Longwood, FLN6241ERuijne Leo L · Plainview, TXN6241FBucks Mont Masonry Inc · Green Lane, PAN6241NSt Croix Recreation LLC · Mulberry, FLN6241RHayhurst Shane R · Winfield, PAN6241TArm 4 Aviation LLC · Blanchard, IAN62425Dodson International Parts Inc · Rantoul, KSN62429Fowler Cary D · Hayti, MON6242EDenson Randy A · Meridian, IDN6242FAzul Services LLC · Bozeman, MTN6242GSpencer Aviation Inc · Delaware, OH
Back to AD 79-10-14 R1