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.
N823CKSpirit Aviation Management Services Inc · Thomson, GAN823CSRouch Timothy · Sturgis, MIN823DAb Prop Plane II LLC · Metairie, LAN823EPEpic Aviation Inc · New Smyrna Beach, FLN823FStout Philip L · Ephrata, WAN823KSKansas State University Salina · Salina, KSN823LCBonafide LLC · Wilmington, DEN823MCN823mc LLC · Kennesaw, GAN823PWSpradley Jeff D · White Springs, FLN823SRLandmark Aerial LLC · Metuchen, NJN823TMMarther Thomas L · Albion, PAN823WSMcinturf Paul A Jr · Childress, TXN8240F14a Flying Club Inc · Mooresville, NCN8240LCactus To Clouds Aviation LLC · Indio, CAN8240ZSingleton Shermann S · Farmington, NMN8241BBalint Jozef · Fort Worth, TXN8241GSilvers Clarence W III · Holden, MON8241MVenema-Ashmore Karin · East Dixfield, MEN8241URegistration Pending · Casa Grande, AZRegistration pendingN8241VAlsworth Glen R · Port Alsworth, AKN8241XRotormate LLC · Royse City, TXN8242BLibby Robert E · Windham, MEN8242GValdez Acela Rangel · Maricopa, AZN8242XSadique Said-Hesamadine · Fairfax, VAN8243EMacon Air LLC · Franklin, NCN8243GGebauer David Lee · Jackson, CAN8243MBundy Holdings LLC · Walnut Grove, MON8243XDemetreu Thomas J · Almond, NYN8243ZHogscanfly LLC · Wagner, SDN8244AMiles Robert A · Maupin, ORN8244GHughes Jeffrey D · Roseburg, ORN8245AAdriatic Holdings LLC · Cheyenne, WYN8245FMorisette Michael W · Antelope, CAN8245GSchultz Jeffrey R · Dayton, OHN8245MSea Seven LLC · Weatherford, TXN8245VFarnsworth James A · Sandy Valley, NVN8245ZByrum Scott L · Avondale, AZN8246BBoyer Christopher · Bozeman, MTN8246FTalikka Todd · Paulding, OHN8246LPatak Eva L · Ennis, TXN8246ZChak Chak LLC · White Salmon, WAN8247BDoughty Robert W · Casa Grande, AZN8247FCarson Leonard H · Chesapeake, VAN8247LKnepp Terry · Montgomery, INN8247UComeau Paul D · Walden, NYN8247ZBeam Troy A Trustee · Shippensburg, PAN82488Simpson Patrick E · Ketchum, IDN8248AEllis John D · Hodgenville, KYN8248FLucia Steven R Sr · Agawam, MAN8248GSchuster Peter E · Dundee, OH
Back to AD 79-10-14 R1