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.
N8877TAnderson Robert M · Merritt Island, FLN8877USmith Stephen A · Aloha, ORN8878UBallard Ralph T · Hurricane, UTN8879BKatsahnias George T · Denton, TXN8879XKlingelhoffer Jeffrey A · Olympia, WAN887CMHigh Top LLC · Leclaire, IAN887CPCivil Air Patrol · Maxwell Afb, ALN887EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN887JBBertrand Carolyn L · Ridgecrest, CAN887PBZankiz Jose Carlos · Naples, FLN887WQuad City Area Flying Eagles Inc · Milan, ILN887WBJones Brandon · West Bountiful, UTN8880Causey Dale L · Albuquerque, NMN88808Thompson Patrick M · Madera, CAN8880TAltitude Air LLC · Sheboygan Falls, WIN8880UJackson Todd · Spirit Lake, IDN8881Steadfast Ministries · Alton, TXN8881NHero Enterprises LLC · Panama City Beach, FLN8881VLien Ronald N · Gilford, NHN8881XFluegel Justin D · Gresham, ORN8882Landiedel Thomas DBA · Spokane, WAN8882GSchauer Tad J · Lake Park, MNN8882SHudson Willis · Hendersonville, NCN8882TWarrington Christopher · Indn Hbr Bch, FLN8882VTop Aircraft Leasing LLC · Wilmington, DEN8882XMyrtle Aviation Inc · Wichita, KSN8883BMoe Jean A · Detroit Lakes, MNN8883GPalacios David J · Yucca Valley, CAN8883TBishop Nicholas Edward · Ukiah, CAN8883XMyrtle Aviation Inc · Wichita, KSN8884BBrunson Aviation LLC · Little Elm, TXN8884SMechin Jean-Michel S · Gardiner, NYN8884XMckinley Michael S · Florence, AZN8885GGurley George R · Caledonia, MSN8886BNeil John L Sr · Port Huron, MIN8887XEighty Seven X-Ray LLC · Atlanta, GAN8888TKraus Paul B · Fort Bragg, CAN8888URomano Michael A · Fresno, CAN8889BDelise Nicholas M · Manteno, ILN8889UJennings Chadwick B · Reno, NVN8889VGarcia Hector A · Caguas, PRN888ABRegistered aircraftN888AKElliott David B · Dallas, TXN888BAmerican Airpower Museum · Farmingdale, NYN888BGOgden Thomas C · New Cumberland, WVN888BLBillings Daryl DBA · Henderson, CON888BTSpraymax Corp · Miami, FLN888CBBenz James E · Pittsford, NYN888CMKelley Aircraft LLC · Weyers Cave, VAN888CTNorthland Beverage Inc · Flagstaff, AZ
Back to AD 79-10-14 R1