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.
N9847LJoerithan & Mp Aviation LLC · Whittier, CAN9847VWinder Editha S · Columbus, NMN98485Amelia Reid Aviation LLC · San Jose, CAN9848GRicci Mark P · Waterford, MIN9848HBrekke Ryan S · Edmore, NDN9848JLanham David R · Visalia, CAN9848MCovington Aircraft Engines Inc · Okmulgee, OKN9848TMueller Scott A · Garden Prairie, ILN9848VSuperhawk Flight LLC · Plano, TXN98492Henry Mark Alan · Dickinson, TXN98494Noggle William L · Warthen, GAN9849GPray Aviation Inc · Augusta, KSFirst renewal noticeN9849HSouthwest Plane Holdings LLC · Kalispell, MTN9849LDynasty Adventure Inc · Wilmington, DEN9849QBriggs Christopher T · Manchester, NHN9849TRushing Kevin W · Marks, MSN984AVAtp Aircraft 1 LLC · Wilmington, DEN984BTMoore Aviation Inc · Beaver Falls, PAN984CPCivil Air Patrol Inc · Maxwell Afb, ALN984FAFreedom Aviation Inc · Lynchburg, VAN984JAKinman Plumbing Co Inc · Louisville, KYN984JSFvx Research · Bristow, VAN984PDLegends Air Center LLC · Bentonville, ARN984SPRedstone Arsenal Flying Activity · Redstone Arsenal, ALN984WUMoore Aviation Inc · Beaver Falls, PAN98502Sky Warrior Flight Training Inc · Pensacola, FLN9850VPropability One LLC · Daytona Beach, FLN98510Touch-N-Go Flying Club Inc · Hillsboro, INN9851HCivil Air Patrol Inc · Montgomery, ALN9851JPlanepower LLC · Meridian, MSN9851XWheeler Andrew C · Orting, WAN98525Trns Solutions LLC · Lewes, DEN9852JG & M Associates LLC · Quitman, GAN9852TRead Colin L · Plattsburgh, NYN98530Swan Aviation Ministries Inc · Crestview, FLN9853GParker Steve E · Palmer, AKN9853HMiles Alexander Bevans · Columbia, SCN9853JEastern Kentucky University Center For Aviation · Richmond, KYN9853LTrend Vector Aviation Int · Barrigada, GUN9854JAdams James P · Wilbraham, MAN9854TMcdowell Bryan D · Blooming Grove, TXN9854XOverly Terrence L · Tok, AKN9855GChoctaw Nation Of Oklahoma · Durant, OKN9855TJkc Farm LLC · Chinook, MTN9855XMcgee Jacob Quinton · King Salmon, AKN98561Blue Sky Flight Training LLC · Hamilton, OHN9857GLeaseair LLC · Wilmington, DEN9857JReiss Alan T · Puyallup, WAN9857TJones Mark E · Milwaukee, WIN98580Flying Farmers LLC · Clewiston, FL
Back to AD 79-10-14 R1