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.
N6402FMaier Andrew J · Barnesville, MNN6402NManos Con Alas Aviation · Stateline, NVN6402VG&M Aircraft Inc · Wheat Ridge, CON64034State Of Louisiana · Baton Rouge, LAN64035Loomis Darwin · Mooreland, OKN6403EGultch Dale R · Brookfield, WIN6403FFertile Flying Club Inc · Fertile, MNN6403GKassel Willard C · Sicily Island, LAN6403TSawicki Michael T · Midland, MIN6403VVista Aviation Inc · Pacoima, CAN64040Golding Donald J · Tucson, AZN64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeN64044Johnson Lance D · Duluth, MNN64045Walker Robert · Chula Vista, CAN64046Biesecker Michael Gary · High Point, NCN64048Gray Peter A · Salinas, CAN6404FHigh Demand Earthworks & Vineyard Development LLC · Napa, CAN6404GWarrior Aviation LLC · Prior Lake, MNN6404TWestrum Enterprises LLC · Norwalk, IAN64053Collins Thomas A · Orleans, MAN64056Angel Aviation Inc · Peoria, AZN6405ERiggs Bradley A · Emporia, KSN6405GArmond Richard J · Thousand Oaks, CAN6405TBrunks Paul D · Peachtree City, GAN6405XArctic Aviation Leasing LLC · Anchorage, AKN64061Stark Glenn M · Nampa, IDN64062M G Enterprises Of Albert Lea Inc · Alden, MNN64063Bowers Alan B · Bellevue, WAN64065Lg Holdings LLC · Gretna, NEN64067Duvall Chris D · Tahlequah, OKN64069Whiskey Tango Aviation LLC · Keene, NDN6406BWojtacha Jacob M · Wasilla, AKN6406EOwczarek Przemyslaw J · Hampton Bays, NYN6406KWandell Daniel J · Murfreesboro, TNN6406XIronsides Custom Grinding Inc · Waitsburg, WAN64074Green Norman D · Lake City, FLN64079Portneuf Holdings LLC · Chubbuck, IDN6407BMclean Diane A · Weirsdale, FLN6407DWalo Enterprises LLC · Aurora, CON6407EN6407e LLC · Hanover, MDN6407TKane Erik W · Mojave, CAN6407VWard Matthew A · Fort Worth, TXN64081Burrows Donna M Trustee · Grain Valley, MON64082Mcdonald Douglas W Sr · Cornelia, GAN64087California Airways LLC · Hayward, CAN6408EMorgan Lloyd J · Memphis, MON6408GWebb Joe R · Union, WAN6408KShowah Michael F · Scottsdale, AZN6408NBorders Nowell W · Edinburg, TXN6408THowland Timothy A · Mankato, MN
Back to AD 79-10-14 R1