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.
N4887ZJav Air Services LLC · Anchorage, AKN4888CGoflight Inc · Birmingham, MIN4888DRegistered aircraftN4888FTaktos Ltd · Corvallis, ORN4888G578 Airplane Leasing Inc · Kissimmee, FLN4889DPink Skies Inc · Willoughby, OHN4889GKittitas Aero Inc · Kittitas, WAN488BAPlane Nonsense Inc · Middletown, DEN488EMBishop Patrick M · Reading, MAN488EREmbry Riddle Aeronautical University · Daytona Beach, FLN488JWKagey David M · Seabrook, TXN488RAWest Bottoms Properties Inc · Iola, KSN488RHI F Rooks & Associates LLC · Memphis, TNN488WMMackey Ken G · Ridgeville, SCN4890FSkyline Sheet Metal Inc · Troutdale, ORN4890QNew Frontier Aviation LLC · Fort Benton, MTN4890RRebecca Lynn Flying Service Inc · Livingston, NYN4891EHerman Darrel K · Lebanon, ORN4891JHarris Aircraft Leasing Co · Oklahoma City, OKN4891ZRustair Inc · Anchorage, AKN4893DMazone Robert J · Deer Park, WAN4893ELjl & D Inc · Wilmington, DEN4893GBoldflight LLC · Greenwood, INN4893JMartineau Aircraft Inc · Butte, MTN4895DMissouri Aviation Inc · Leeton, MON4895EWestern Big R Inc · Burns, ORN4895GWilson Forest B · Hollister, CAN4895VEbrite Richard P · Long Beach, MSN4895YKeating George W · Fayetteville, ARN4896CFlying Paws LLC · Arvada, CON4896DBrown Jason · Edwards, CON4896EMcgrail Stephen M · South Dennis, MAN4896FPorter Carl S · Seymour, TXN4896GGecha Richard Mike · Florence, VTN4896MSmtm Holdings Inc · Wilmington, DEN4896QBecker Flying Service Inc · Hartington, NEN4896RB&R Aerial Crop Care Inc · Connell, WAN4896VSouth Aero LLC · Albuquerque, NMN4897DHall Leah · Diamond Springs, CAN4897ESig Flights LLC · Hickory, NCN4897GWings Over Texas Holdings LLC · Denton, TXN4898CPalo Aerocraft Inc · Salem, VAN4898DAcute Holdings LLC · Jenks, OKN4898FLima-001 LLC · Muscatine, IAN4898QTaylor Aviation Inc · Fort Benton, MTN4899GJf Property Leasing Inc · Port Orchard, WAN489BCAviation Services Inc · Barre, VTN489ECRobertson James T · Forest Lake, MNN489ERMenefee Scott A · Los Banos, CAN48ALHutchinson Scott · Missouri City, TX
Back to AD 79-10-14 R1