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.
N759SLSirmon James A · Daphne, ALN759SPCivil Air Patrol Inc · Maxwell Afb, ALN759SRMazz Airplane 1 LLC · Elbert, CON759TAKay Betty T · Brigham City, UTN759TDHollingshead Michael · Murfreesboro, TNN759TFGardner Robert · Bellevue, IDN759TGTwgr LLC · Amarillo, TXN759THJones Darrell · Columbia, MON759TJFlying Anchor Aviation LLC · Seattle, WAN759TMCastro Joseph · Boston, MAN759TNAir Charter Inc DBA · Culebra, PRN759TPItaliano William S Jr · West Boylston, MAN759TRArnold Scott J · Xenia, OHN759TSWinter Kevin A · Ravensdale, WAN759TTTrend Companies LLC · Phoenix, AZN759TURobeck Troy D · Okanogan, WAN759TVJimmy Mac LLC · Sun Valley, IDN759TYKoopman Allen W · Lake Forest Park, WAN759UCCozart Marlon R · Azle, TXN759UHAyerstech LLC · Chetek, WIN759UJKing Forest Ind Inc · Wentworth, NHN759ULJav Air Services LLC · Anchorage, AKN759UQPatrick William B · Newport News, VAN759URStenzel Richard J · Imperial, PAN759USFly Ab Inc · Fort Lauderdale, FLN759UUMeyerson Sanford · Smithville, TXN759UVChamberlain Noreen J · Douglas, WYN759UWKaufmann Michael A · Brownsburg, INN759VPacific Coast Aero LLC · Torrance, CAFirst renewal noticeN759VGDodson International Parts Inc · Rantoul, KSN759VHSaguto Peter J · Ballwin, MON759VJMoffitt John S · San Jose, CAFirst renewal noticeN759VMJuliet Mike Holdings LLC · Friendswood, TXN759VNHoney Cross Farms P/S · Lafayette, LAN759VPLewis Elliott Mcmorran Vaden Ragsdale & Woodward · Little Rock, ARN759VVHumble John A · Liberal, KSN759VYAms Aviation LLC · South Bend, INN759WDTootle Equipment Co Inc · Reidsville, GAN759WERegistration Pending · Cottonwood, AZRegistration pendingN759WGFtm Falcon LLC · Arnold, MDN759WKLee Kevin J · Dunn, NCN759WLStolyarov Yury M · Brookline, MAN759WMJames Brent A · Royal, ARN759WNSmith Kristopher D · Wickenburg, AZN759WPSale Reported · Farmington, MOSale reported, pending cancellationN759WRAlmond Kevin L · Waxahachie, TXN759WSCottrell David J · Anchorage, AKN759WWLeading Edge Aviation Services Inc · Missoula, MTN759WZMario J Khoury · Pasadena, CAN759XBjorlie Paul A · Pekin, ND
Back to AD 79-10-14 R1