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.
N5793ELowe David M · Sacramento, KYN5793RRogers Jesse E · La Belle, MON5793TJefferson County Public Schools · Louisville, KYN5794APerkins Larry L · Wildomar, CAFirst renewal noticeN5794RMacfarland Donald C · North Tonawanda, NYN5794TGodfrey Kenneth E · Oroville, CAN5795BJst Management LLC · Zephyrhills, FLFirst renewal noticeN5795CHancock James T · South Saint Paul, MNN5795ERose Walter W · Arena, WIN5795GRhodes Tom B · Dallas, TXN5796CJohnson Terry A · Idaho Falls, IDN5796JRegistered aircraftN57977Denney Dennis · New Port Richey, FLN5797AEver Fast LLC · Kalispell, MTN5797CNorris Terry F · Rockford, ILN5797FWright James J · Owens Cross Roads, ALN5797JLindsay Properties LLC · Kosciusko, MSN5797RRiggs Laura A · Middleburg, FLN5798ABowman Ronald J · Bellefonte, PAN5798EPineapple Flyers Inc · Rockville, MDN5798RRatcliff Bruce A · Plain City, OHN5799AMiller Lavon S · Eureka, NVN5799CLewellen Donnie J · Friona, TXN5799GBafa LLC · Lewes, DEN5799JBritt Demolition And Recycling Inc · Hanceville, ALN5799TGs Air LLC · Sioux Falls, SDN579BWBridgewater State University · Bridgewater, MAN579CPCivil Air Patrol · Maxwell Afb, ALN579ER22 H20 LLC · Montgomery, TXN579JDForst Kenneth D DBA · Grand Rapids, MNN579JKKopacz Thomas H · Glen Flora, WIN579KRed Plane Aviation LLC · Key West, FLN579MAJones Andrew W · Turner, MTN579WGTrede 2021 C172 LLC · Aurora, ORN57BMHuerta Holdings Inc · Santa Ana, CAN57BRRamsey Brent C · Tulsa, OKN57CCavu Aviation LLC · Tulsa, OKN57CABlue Sky Management LLC · Stevens Point, WIN57CSSparkjoy Backcountry LLC · Boulder, CON57DLGarrett Gary M · Reno, NVN57EAEwing Andrew M · Santa Rosa Beach, FLN57FASilver Express Co DBA · Miami, FLN57FFWingsleasing LLC · Wichita, KSN57HKell Thomas G · Anchorage, AKN57MJFrederick Bradley W · Corvallis, ORFirst renewal noticeN57MTYee Michael P · Missouri City, TXN57MWFogal Brian K · Chambersburg, PAN57PHEldredge Bradley P · Highland, UTN57UDAlf Ix LLC · Chicago, ILN57VBKlingebiel Kurt · Leonardtown, MD
Back to AD 79-10-14 R1