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.
N7180GPearman Properties LLC · Branson, MON71811Weed Eater LLC · Canton, OHN71812Flight Patterns LLC · Okanogan, WAN71815Whipple Daniel C · Coon Rapids, MNN71818Price Norman S · Prineville, ORFirst renewal noticeN7181AWarmkessel James R · Felton, CAN7181FCarter Mark A · Carpinteria, CAN7181MArmstrong Bruce · Port Orchard, WAN7181TSwanson G N · Meridian, IDN7181XMozina Robert J · Mc Alpin, FLN71821Hayes Harlan L · Salem, ORN7182AEdm Flying Inc · Nevada, MON7182EShoreline Consulting Inc · Bryan, TXN7182GBar-Od-4 Cattle Co LLC · Laredo, TXN7182MThayer Stephen Claude · High Point, NCN7182QMullins Albert A · Boling, TXN7182SHoward William M · Greensburg, PAN7182TTdp LLC · Caldwell, IDN71831Kellogg Morgan · Missoula, MTN71833Vega Al · Windsor, CAN7183AElk & Ram Aviation Group LLC · San Antonio, TXN7183FN7183f LLC · Spanish Fork, UTN7183MSnavely Deborah B · Lake Placid, FLN7183QFlying Wild LLC · Yarmouth, MEN71844Rusinsky Michael John · Amagansett, NYN71846C3 Aviation LLC · Eustis, FLN7184AGarrison Randy L · Queen City, TXN7184FYoke Aviation LLC · Bowling Green, KYN7184QHolubar Properties Inc · Mckinney, TXN7184SCade Steven V · Lopez, WAN7184THelderman Laban W · Newton, NCN7185ENenadic John P · Camas, WAN7185GJones Mark R · Denton, MDN71860Young Reginald L · Fort Worth, TXN71866Lkn Skylane LLC · Mooresville, NCN71867Friend Troy L · Wyandotte, OKN7186AValiair Lc Trustee · Casper, WYN7186CRegistered aircraftN7186SEagle Equity Inc · Valparaiso, INN7186XSmith Calvin E · North Augusta, SCN71876Rasmussen Paul · Long Lake, NYN71879Sale Reported · Greeley, COSale reported, pending cancellationN7187AHannah David W · Richmond, TXN7187FHoranzy Paul S · N Grosvenordl, CTN7187QChestnut Ridge Flying Club · Latrobe, PAN7187RFlying Roaches LLC · Dallas, TXN71880Meeks Michael D · Marion, TXN71884Smith John L Trustee · Zephyr Cove, NVN7188EWashick Timothy J · South Lake Tahoe, CAN7188FCopeland Lance Andrew · Jacksonville, AR
Back to AD 79-10-14 R1