AD 69-12-03
Registered aircraft · 323
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:69-12-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:69-12-03')
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:69-12-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:69-12-03') 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.
N102JRRutkosky John J DBA · Palm Coast, FLN105LRegistered aircraftN107YYBeezhold Terence J · Lake Stevens, WAN10PRVillalobos Jesus F · Farmington, NMN1113TWirthlin Donald K · Sierra Vista, AZN11220Southern Arkansas University Tech · Camden, ARN112HRFlexer Howard · Monterey Park, CAN115CKSchmick Kenneth R · Fond Du Lac, WIN116BGGood Bill T · Temecula, CAN1181FPatel Jayesh V · Titusville, FLN1188Persky Adam · New Bern, NCN1189MQuality Aviation Inc · Marana, AZN11DEPeile Kelly · Lakeview, ORN11SLJohnson Randy L · Pikeville, KYN12144Pittsburgh Institute Of Aeronautics · West Mifflin, PAN123DEGearhart John D · Arlington, WAN125ETGrindeland Ethan P · Hatton, NDN129CMWoodhaven Air LLC · Blue Springs, MON1361QLannigan Anthony Robert · Tucson, AZN137Bigfoot Aviation LLC · Saint Michael, MNN1491Petecraft Aviation Services Inc · Plains, GAN153RJones Jeremy R · Lampasas, TXN16SGWard James · Arroyo Grande, CAN1710HQuon Nicholas · Fayetteville, GAN1712HColvin Clu D DBA · Big Cabin, OKN1718HSale Reported · Bartlesville, OKSale reported, pending cancellationN1722HWashington State Community College · Spokane, WAN1731HDonadio Robert F · Amherst, NHN1760HReeve Howard E · Minot, NDN1766HOrlandi Properties LLC · Blairstown, NJN1777HFait Coleman B · Newport Beach, CAN1783HRegistration Pending · Anchor Point, AKRegistration pendingN1797HRons Air Service Inc · Two Buttes, CON1811HLeggett Jason · Bogue Chitto, MSN1816HKiever Robert P · Summerland Key, FLN1827HWard Austin · Kokomo, INN1831HKulp Clayton H · Wichita, KSN1837HYeagley Daun III · Moraine, OHN1852HI Fly Stl LLC · Saint Louis, MON1856HVieman John D · Owensville, MON1862TBradley Max T II · West Plains, MON1873HBlue Canoe Aviation LLC · Chicago, ILN1879HRegan Robert C · Kent, WAN1886HGoodwin Joseph N · Grass Valley, CAN191RAnderson Harold E · Phoenix, AZN1956Sturges George S Jr · Bakersfield, CAN196RLunsford Joel T · Jasper, TXN200LEAeromarine Holdings LLC · Waukesha, WIN215AMurphy Dan A · Two Harbors, MNN2199CMorris Thomas B · Imlay City, MI
Back to AD 69-12-03