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.
N8214ARozycki Seth · Little Falls, MNN8214FHoneycutt David · Columbus, MSN8214GKolman Michael D · Overland Park, KSN8214UN8214u LLC · Sheridan, ARN8214XStroemsvik Kristian · Strasburg, VAN8215GGersten Iron · Spring Valley, CAN8215LUmphrey Reid · Douglasville, GAN8215XLaforest Jerome P · White Lake, MIN8215ZRg Aviation Inc · Wilmington, DEN8216ADates Lauren C · Red Creek, NYN8216BBrezina Chad M · Whitewright, TXN8216GFarrar Edwin L · Mansfield, OHN8216JGuth Martin H · Kasilof, AKFirst renewal noticeN8216LWoodworth Mark S · Madison, OHN8216UClinch Jerome J · Lincoln, NEN8216XRiver Town Aviation LLC · Williamstown, WVN8217BRoll George N · Freeport, FLN8217GVne Aviation LLC · Dripping Springs, TXN8217LSteward Kim R · Durand, ILN8217MBas Part Sales LLC · Greeley, CON8217XRiggs John · Punta Gorda, FLN8218FDel Rosario Jose · Hackettstown, NJN8218LTufts Kyle J · Hampden, MEN8218USalley Ronald C · Satellite Beach, FLN8218XEvans James · Millbrae, CAN8219AElder Joel M · Scott City, KSN8219FKietzer Tyler L · Mankato, MNN8219GSchaum Jerome B · Machipongo, VAN8219MFair Winds Group LLC · Portage, MIN8219UShaffer Kenneth H · Trout Lake, WAN8219VGreenman Lisa J · Chesterton, INN8219XCouch James T · Choctaw, OKN821CETedesco Michael Anthony · Monroe, CTN821CPCivil Air Patrol · Maxwell Afb, ALN821DHMilsap Charles M · Owensboro, KYN821EREmbry Riddle Aeronautical University · Daytona Beach, FLN821HGGeorgia Aviation Authority · Eastman, GAN821RMC&C Aero LLC · Billings, MTN821SJc/Rc Ventures LLC · Key West, FLN821SDGlobal Adventures N821sd LLC · Hollywood, FLN821STNorthwestern Michigan College · Traverse City, MIN821WTVest Michael S · South Beach, ORN821WWDouble Whiskey Flyers LLC · Highlands Ranch, CON8220BTurner Travis Joseph · Chetek, WIN8220LFlywyo LLC · Kalispell, MTN8220SHammack Lindsey M · Westlake, TXN8220XGundry James A · Fall Creek, WIN8221BMayberry Jonathan J · Lake Stevens, WAN8221FSale Reported · Eau Claire, MISale reportedN8221GIshoy Glen · Indiana, PA
Back to AD 79-10-14 R1