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.
N8786USchlosser Bryan Andrew · Sudlersville, MDN8786XCedar Valley Air LLC · Lehi, UTN8786ZNordstrom Hans P · Wasilla, AKN8787BHedgers Thomas W · Lino Lakes, MNN8787Q2fly Safety LLC Trustee · Azle, TXN8787UMoody Bible Institute Of Chicago · Spokane, WAN8787ZKing Farm Partnership · Mccrory, ARN8788GWagenaar Diane D · Frankston, TXN8788QKochert Timothy B · Anchorage, AKN8788UIzard Ryan S · Nacogdoches, TXN8788XAero Cg LLC · Fresno, CAN8789TChristiansen Aviation LLC · Wilmington, DEN8789ULangley Bryan T · Springfield, OHN8789XWinfreds Legacy LLC · Oneonta, ALN8789ZParrott Charles F · Saugus, MAFirst renewal noticeN878CPCivil Air Patrol · Maxwell Afb, ALN878EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN878JMVaughan William F · Henryville, INN878JWRegistered aircraftN878SATampa Bay Aviation Inc · Clearwater, FLN8790TGray Teddy G · Scarbro, WVN8790UPonte Ralph M DBA · Grass Valley, CAN8790XTyler Ronald D Jr · Harlingen, TXN8791BCook Robert G · Rensselaer, NYN8791TStoesz Chad G · Hailey, IDN8791XJoseph Gary W · Torrance, CAN8792TFanning Fred W · Fairlawn, OHN8792UBenair LLC · Bonita Springs, FLN8792XN8792x LLC · Loveland, CON8792ZPerkovich Brian T · Oneida, WIN8793TWilkinson Daniel · Brownwood, TXN8793XFowler Kristina M · Georgetown, CAN8794SUS Flight Academy International Inc DBA · Post, TXN8794TWilcox Rhonda R · Boulder, CON8794UMock Joseph R · Huntsville, TXN8794XSpencer Stacia L · Pomona, KSN8794ZJones Petroleum Co Inc · Jackson, GAN8795BE2 Technologies Inc · Grand Haven, MIN8795GDesousa Raphael · Fremont, CAN8795QWright Air Service Inc · Fairbanks, AKN8795SHuffman Jacob M III · Burleson, TXN8795ZNeuschaefer George H · White Hills, AZN8796BTetrault Phil H · Chisago City, MNN8796GSouthwest Texas Junior College · Uvalde, TXN8796QSpangler Robert E · Anchorage, AKN8796SSkylane Of Willmar LLC · Willmar, MNN8797GTriplett Joseph C II · Pontotoc, MSN8797USowers Harry D · S Bloomingville, OHN8797ZCjc Enterprises LLC · Erda, UTN8798GMclemore Cecil E · Woodland, CA
Back to AD 79-10-14 R1