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.
N4803GAarow Aircraft Leasing LLC · Mcminnville, ORN4803QBruntz Leslie H · Oxford, NEN4803WRollins Brian D · Smithville, MSN4804Pixel King 01 LLC · Fort Worth, TXN4804EPrestar Inc · Davis, CAN4804NMueller Scott · Somis, CAN4805GTidewater Flying Club Inc · Newport News, VAN4805URice Gary B · College Place, WAN4805VBudulas Peter Panagiotis · Laurel, MDN48061Olsen Mark G Trustee · Ketchikan, AKN4806GStone Howard L · Pine Mountain, GAN4806NGibson Ronald M · Laurel Hill, NCN4806YCondor Aviation LLC · Hanover, NHN48071Burns Craft LLC · Wilmington, DEN4807DRussell Matthew D · Chattaroy, WAN4807FWinkler Jeffery L · Brush, COFirst renewal noticeN4807GAdnd LLC · New Ipswich, NHN4807JNew England Aviation LLC · Plainville, CTN4807LEddy Richard C · Hurricane, UTN4807PMadigan Michael · Maryville, TNN4807XHile Daniel A · Clearfield, PAN4808DLmnb LLC · Centreville, VAN4808FYankee Flying Club Inc · Maple Grove, MNN4808GClub Aero Inc · Grand Rapids, OHN4809Miller Wade · Hot Springs, SDN48091Krueger Luke T · Anchorage, AKN4809DRanger Timothy R · Anchorage, AKN4809ETownsend Robert · Leavenworth, WAN4809NNewland John G · Eagle, IDN4809USchutze Curt K · Santa Paula, CAN4809XKc Aviation LLC · Kalispell, MTN480ERFlying Off Leash Aviation LLC · Daniel Island, SCN480SPDhs Operations LLC · Wilmington, DEN480WLRocky Mountain Flight Consultants LLC · Boulder, CON4810Cox John C · Justiceburg, TXN4810GAndrecheck Cynthia R · Bethel, AKN4810YInternational Air Services Inc Trustee · Carson City, NVN4811DAbidance Inc · Winthrop, WAN4811FHurlston Glenn D · Leesville, LAN4811GPoplar Grove Airmotive Inc · Poplar Grove, ILN4811JSeals Kenneth P · Munford, ALN4811NMiller Edwin C · Proctor, WVN4811USwartz Ryan W · Pierre, SDN4812CRennekamp Eric J · Andersonville, TNN4812FNorth American Aerial Surveys LLC · Tucson, AZN4812UFoster Frank Brian · Goldsboro, NCN48136Morrison James J II · Grandview, TXN4813CCivil Air Patrol · Maxwell Afb, ALN4813GBasso Michele · Millbrook, ALN4814Crawford Benjamin D · Anchorage, AK
Back to AD 79-10-14 R1