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.
N7700FClairy Scott M · Justin, TXN7700HBrensing Steve E · Stafford, KSN7700UJarvis Tree Service Inc · Heber Springs, ARN7700XRule Paul Crane Trustee · Wapato, WAN7701FRegistered aircraftN7701UIyer Sundaresh R · Northborough, MAN7702EWhite Don DBA · Mount Vernon, WAN7702KRose Hugh S · Fairbanks, AKN7702TNablo Dustin · Haddam Neck, CTN7702VBrown Warren C · Pasadena, CAN7703FGonzales Donald M · Columbia Station, OHN7703TRegistered aircraftN7704UAllen Philip · Portland, ORN7704XStark Linda L · Arroyo Grande, CAN7705EGerber James R · Larchwood, IAN7705FEisel Joseph D · Dexter, ORN7705UCaldwell Evan-James Gray · Camano Island, WAN7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKN7707AGay Chris · Anchorage, AKN7707TAmerican Petro Inc · Ball Ground, GAN7707UMeese Brian D · Conroe, TXN7708AFrelin Josef J · Anchorage, AKN7708UDahle Jacob J · Morristown, MNN7709FChiang Yucheng · Glenview, ILN770CBTeton Avjet LLC · Driggs, IDN770CDCunningham Campers & Rvs · Clarksville, INN770CFKopp Adrian D · Brookville, INN770HTailwind Aviation LLC · Huntingburg, INN770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILN770SPHa Emily J · Fort Worth, TXN7710TMorton David W · Brady, TXN7710XGraves Robert D · Elberton, GAN7711AMckay Donald A · Soldotna, AKN7711DCaldwell Joel A · Kenai, AKN7711EHeaton Stewart · Spanish Fork, UTN7711FMcclain Eugene L · Maryville, TNN7711LClick Justin T · Hobart, INN7711TBaker Eddy · Waynesville, ILN7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeN7712AMizer James D · Hailey, IDFirst renewal noticeN7712UGolding James M · Diamond Springs, CAN7713EFitzgerald Keith M · Coopersburg, PAN7713GDavenport Jimmy J · Hayesville, NCN7713THatton Daniel R · Portland, ORN7713UDavisson Paul V · Jupiter, FLN7714ALawyers Real Estate Services LLC · Hondo, NMN7714FRegistration Pending · Oxford, MIRegistration pendingN7714GGlynco Manning Aviation Inc · Brunswick, GAN7714UKimbrell Quentin · Cape Girardeau, MON7714XLenhardt Edward J · Green Lane, PA
Back to AD 79-10-14 R1