Skip to content

Registered aircraft · 56,580

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

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

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.

N4262FHayton James B · Sedro Woolley, WABuilt 1958 · S/N 46162 N4262UCrump Matthew A · Weatherford, TXBuilt 1963 · S/N 15060262 N4262VKinzie Industries LLC · Alva, OKBuilt 1948 · S/N 18618 N42631Ga Elite LLC · Camarillo, CABuilt 1968 · S/N 18259115 N42632Hebert Mark R Trustee · Lakeville, MNBuilt 2022 · S/N 18283184 N4263LCox Dennis J · Beach City, TXBuilt 1966 · S/N 17254332 N4263UAdam Johnson · Sunray, TXBuilt 1964 · S/N 15060263 N4263VUltra Flight LLC · Le Mars, IABuilt 1948 · S/N 18619 N42645Williams Ray H Jr Trustee · Austin, NVBuilt 1968 · S/N 18259120 N42647Glenwood Tank Facility LLC · Ramsey, MNBuilt 1968 · S/N 18259121 N42648Propwash 182 LLC · Visalia, CABuilt 1968 · S/N 18259122 N42649Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259123 N4264LMcguckin Michael C · Mesa, AZBuilt 1966 · S/N 17254333 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4264UJones Craig R · Brighton, MIS/N 15060264 N4264VLubben Ryan D · Fergus Falls, MNBuilt 1948 · S/N 18620 N42652West Dennis M · Lexington Park, MDBuilt 1968 · S/N 18259124 N42653Stockwell William · Dowagiac, MIBuilt 1968 · S/N 18259125 N42655Hawes Pamela M · Lancaster, MABuilt 1968 · S/N 18259126 N4265CHunt Delbert O · Dillon, MTBuilt 1968 · S/N 15068178 N4265FRedding Steven R · Skiatook, OKBuilt 1958 · S/N 46165 N4265L1515 Aviation LLC · Burleson, TXBuilt 1966 · S/N 17254334 N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4265VByler Jonathan P · Inman, SCBuilt 1948 · S/N 18623 N4266298x LLC · Caddo Mills, TXBuilt 1968 · S/N 18259128 N4266FCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1958 · S/N 46166 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N4266UDoyle Paddy B · Homedale, IDBuilt 1963 · S/N 15060266 N42672Dowden Lairon W Jr · Nederland, TXBuilt 1968 · S/N 18259131 N42673Chase Donald C · Erie, PABuilt 1968 · S/N 18259132 N42678Merow Michael C · Algoma, WIBuilt 1968 · S/N 18259135 N4267FValenzuela Kevin · Totowa, NJBuilt 1958 · S/N 46167 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 N4267UZeiset Luke R · Manchester, TNBuilt 1964 · S/N 15060267 N42687Cal Coast Reps Inc · Costa Mesa, CABuilt 1968 · S/N 18259138 N42689Alc Aviation LLC · Waseca, MNBuilt 1968 · S/N 18259140 N4268UWhitby Devin A · Dumfries, VABuilt 1964 · S/N 15060268 N42693Paul D Barkhurst Pc · San Antonio, TXBuilt 1968 · S/N 18259141 N42694Jaffa Bruce E · Moose Pass, AKBuilt 1968 · S/N 18259142 N42698Bruch Stein · Randolph, MNBuilt 1968 · S/N 18259145 N4269FPerkey Gilbert J Jr · Eagle Rock, VAS/N 46169 N4269LBussey Stuart · Lafayette, CABuilt 1966 · S/N 17254338 N4269VDouglas Phillip A · Fredericktown, OHBuilt 1948 · S/N 18627 N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590 N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688 N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827 N426EPKentucky Airmotive Inc · Mount Sterling, KYBuilt 1998 · S/N 17280647 N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263 N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050 N426JGAero Flight School No7 LLC · Lincoln Park, NJBuilt 2008 · S/N 172S10862

Back to AD 79-10-14 R1