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.
N5674RSpellman Mark · Novi, MIN5674TPerma-Culture Inc · Dade City, FLN5675AMarch David H Trustee · Lincoln, CAN5675BMontgomery Richard G · Garden City, IDN5675GGray Mark J · Muncie, INN5675RN5675r Corp · Rochester, NYN5675TPhillips Michael · Thompson Falls, MTN5676ALakes Area Aviation LLC · Little Falls, MNN5676CStearman John T · Collinsville, OKN5676GSchmidt Gary L · Afton, MNN5676JLunsford Group Inc · Asheville, NCN5677BHope Aviation LLC · Hope, IDN5677GFredenburg Justin N · Edgeley, NDN5677JGfp Reserve LLC · Punta Gorda, FLN5678ABailey David D · Twentynine Palms, CAN5678ESchutte Eric J · Newport, WAN5679ALeblanc Kenneth E · Franklinton, LAN5679JFitzgerald Aviation LLC · Bluffton, SCN5679RSandy River Flying Club · Wilton, MEN5679TCataneda Jose · Yakima, WAFirst renewal noticeN567AAAoa Kissimmee Inc · Kissimmee, FLN567BBBeers Suzanne M · Colorado Springs, CON567BHKingsley Kiman J · Miller, MON567CPCivil Air Patrol · Maxwell Afb, ALN567DBGardner Law Firm Pllc · Shawnee, OKN567DDAir America Flight Center LLC · Daytona Beach, FLN567DGFrederick Investment Corp · Raleigh, NCN567DTCenturion Aviation Inc · Kalispell, MTN567GSFlying R LLC · Spokane Valley, WAN567JBHarper Alli B · Joaquin, TXN567JGRapid River Aviation LLC · Boulder City, NVN567JWKingdom Power And Glory LLC · Colorado Springs, CON567MVQuantum Investments Inc · Lincoln, MEN567NDMoore Aviation Inc · Beaver Falls, PAN567SDBordett Jason Scott · Palm Beach Gardens, FLN567SPAb Prop Plane II LLC · Metairie, LAN567TXWatts Brian W · Houston, TXN567XCovert Tim · Portland, ORN5680AMoore John W · Salome, AZN5680BTveitnes Svein T · Whitewright, TXN5680EBenway Peter S · North Salem, NYN5680JKnutson Wayne R · Thompson, NDN5680PHaro Roger E · Eden Prairie, MNN5680RBraun Joshua H · Springfield, MON5681AKiesow Arthur W · Agua Dulce, CAN5682ANewbury Arnold E · Phillips, WIN5683CBaker Mark A · Orangeville, ILN5683GCollege Of Missionary Aviation Inc · Keystone Heights, FLN5683RLewis George H · Brookline, NHN5683TSkydotcom LLC · Inver Grove, MN
Back to AD 79-10-14 R1