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.
N439DCLaguna Sky LLC · Wilmington, DEN439ERMorey Airplane Co Inc · Middleton, WIN439ESH R Management LLC · Bay Saint Louis, MSN439LPTps Aviation LLC · Los Angeles, CAN43AKEarth Center Adventures Inc · Haines, AKN43APSchubert Edward M · Floyds Knobs, INN43DEReynolds Carl R · Bryn Mawr, PAN43FWesterlund Karl D · Eagle River, AKN43FAKingsky Flight Academy LLC · Lakeland, FLN43GFGaskins Joseph Spencer · Port Orchard, WAN43HLKimbrell Heath G · Quinlan, TXN43JKEvans James · Millbrae, CAN43KYPinto Carlos Eduardo · Tucson, AZN43LSLima Sierra Inc · Nappanee, INN43LWRotgers Benjamin Leroy · Malabar, FLN43SLSudtell Chad S · Wasilla, AKN43TBAndreu Kenneth · Valhalla, NYN43TJCyr Philip · Charlton, MAN43VRMountain Ridge Aviation LLC · Millersburg, PAN4400RBophades LLC · Fort Pierce, FLN4400UMax Power Aircraft LLC · Kenosha, WIN4401BJohnson Timothy A · Chisago City, MNN4401LWarbelows Air Ventures · Fairbanks, AKN4401VEwald Christopher R · Blanding, UTN4402BBuffalo Hill Holdings LLC · Sheridan, WYN4402LClements Alex F Jr · Alamogordo, NMN4402QSummers Mark A · Alpine, WYN4402RAvel Aircraft Inc · West Chicago, ILN4403BWhitesell Timothy D · Bend, ORN4403RGorge Aviation Services LLC · Portland, ORN4403VEgbert Harry T · Clarks Point, AKN4405BWelton Doug L · Fairbanks, AKN4405LKopcho Thomas L · York, NEN4405RBon Homme Flyers Inc · Tyndall, SDN4406BAndersen Gregory A · Kenai, AKN4406RDe Nora Christian G · San Antonio, TXN4406VPacific Aviation Aircraft Management Inc · Fresno, CAN4407QSund Manufacturing Co · Newburg, NDN4407RRhyneer Loren S · Anchorage, AKN4408BBrookover Thomas E · Anchorage, AKN4408VScott Tony D · Mangum, OKN4409BDavis John A · Waller, TXN4409RRegistration Pending · Albany, ORRegistration pendingN440ERChristiansen Aviation LLC · Wilmington, DEN440FAA-Cent Aviation Inc · Jacksonville, FLN440SPHoletz Consulting Inc · Minneapolis, MNN4410BRhymes Dustin A · Upland, CAN4410LLenhart James A · Manchester, MIN4410QAyer Benjamin D · Newport, MEN4410RSpane John T · Mount Airy, NC
Back to AD 79-10-14 R1