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.
N767RWWhitt Robert L · Carolina Beach, NCN767VKTextron Aviation Employees Flying Club Inc · Wichita, KSN767XMNew Landing Aviation LLC · Yonges Island, SCN7680GGulyash Michael J · Ukiah, CAN7680KStripe Joseph R · Olympia, WAN7680YMeekin Michael J · Palmer, AKN7681GCompass Aviation Inc · Shelby, NCN7681KNewberry Robert L · Lakeland, FLN7681UTunnel Electric Inc · Shingle Springs, CAN7682MVan De Hei Mike · Pioneer, CAN7682TPittsburgh Institute Of Aeronautics · West Mifflin, PAN7682UTech Flight Corp · South Hamilton, MAN7682XRosenlof Dean F · Tempe, AZN7683GBalgoyen James T · Charlotte, MIN7683MHarmon Katlyn E · Gypsum, CON7683TCleary Michael A · Folsom, CAN7684KWard Keven R · Juneau, AKN7685AAnderson Clarence D Trustee · Anchorage, AKN7685NFranklin Construction Inc · Chico, CAN7687MMckown Kevin · Edgewood, NMN7687XMost Ronald · Apple Valley, CAN7688MCampbell Ronald M · Upland, CAN7688TRodgers Bruce W · Pine Bluff, ARN7688XMauldin Gary · Navajo Dam, NMN7689GMerrihew Jerry R · Ashby, NEN7689MMoreland Wesley · Mckinney, TXN7689TMcclatchey Steven C · Linn Grove, IAN768SPLast Sea LLC · Saint Augustine, FLN7690GScott Kyle J · Fort Morgan, CON7690TFranwick Industries LLC · Westbrook, CTN7690XNeu Aviation LLC · Benton, LAN7691DScout Aviation LLC · Homer, AKN7691GBorden John A · Hoover, ALN7691MKoch Doug L · Wentworth, SDN7691TDewitt Dennis M · Collinsville, ALN7691XAndrade Nelson J · Redwood City, CAN7692MMeyer Lynn O · Olathe, KSN7692UDaso Manuel Sebastian · Spring Hill, FLN7692XJohnson Kevin D · Eldorado, KSN7693GA J L M Partners LLC · Hershey, NEN7693MBaumann William E · Eureka, NVN7693TButler Richard A · Gatesville, TXFirst renewal noticeN7693UPerkins Robert A · New Richmond, WIN7694THeaps John J · Dunlap, IAN7694UDanfelt Eric A · Bend, ORN7694VMarkowski John J · Guilford, CTN7695GPfeifer Kenneth J · Bridger, MTN7695MOboyle Thomas R · Manhattan, KSN7696MForchtner Thomas J · Oklahoma City, OKN7697GFlight School Inc · Spring, TX
Back to AD 79-10-14 R1