Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N661SDDarr Henry S · High Point, NCBuilt 1965 · S/N 24-4354 N6620LMc Gregor Daniel A · Denali Park, AKBuilt 1969 · S/N 31-554 N6621YDyka Samuel M · Flushing, MIBuilt 1969 · S/N 27-4397 N6623YOrtner Airport LLC · Wakeman, OHBuilt 1968 · S/N 27-3930 N6624VDahle Jeffrey R · Ashland, ORBuilt 1970 · S/N 31008 N6627YMiller Jay M DBA · Grantsville, MDBuilt 1969 · S/N 27-4399 N662CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 318052014 N662GSouthwest Property Exchange LLC · Cedar City, UTBuilt 2007 · S/N 40705 N662RKlotz Douglas · Incline Village, NVBuilt 1960 · S/N 39102 N662TMUpright Corp · Kentfield, CABuilt 2004 · S/N T18208247 N662WPHolt Gary L · Ventura, CABuilt 2000 · S/N 4636308 N6631FYah Inc · Wilmington, DEBuilt 1976 · S/N 32R-7780033 N6636VMoss Herman D · Centreville, VABuilt 1970 · S/N 32-32 N6644BN6644b LLC · Cresson, TXBuilt 1958 · S/N 35744 N6644YN6644y LLC · Philomath, ORBuilt 1968 · S/N 27-3958 N6647YSkyway Inc · Wilmington, DEBuilt 1968 · S/N 27-3880 N664RRobertello Gerald J · Centreville, VABuilt 1960 · S/N 39082 N664RSMalibu Inc · Dover, DEBuilt 2000 · S/N 4636313 N6659YUhles Denny · Bakersfield, CABuilt 1968 · S/N 27-3974 N665BCrosby Aviation LLC · Bend, ORBuilt 2001 · S/N T18208011 N6664YSmooth Air Inc · Ocala, FLBuilt 1968 · S/N 27-3980 N666KABeulah Ranch LLC · Cheyenne, WYBuilt 1965 · S/N 1500-177 N666KHMks Aviation Of Mt Airy LLC · Mount Airy, NCBuilt 1972 · S/N 24-5026 N666KWRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 27-7304928 N667CHBorders Darin · Center, TXBuilt 1978 · S/N 32R-7887191 N667RHN667rh LLC · Oakdale, NYBuilt 2002 · S/N 3257290 N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003 N6698VHeberlein Ronald E · Wilsonville, ORBuilt 1966 · S/N 30004 N669CWPrecision Air Inc · Nelson Lagoon, AKBuilt 1969 · S/N 31-514 N669JCloud Splitter Inc · Columbia, CABuilt 1963 · S/N 500B-1304-119 N669PBluhm Daniel A · Gold Hill, ORBuilt 1966 · S/N 24-4507 N66AEAndreassi LLC · Bluffton, SCBuilt 1974 · S/N 31-7405187 N66ATDeer Elm Aviation LLC · Owens Cross Roads, ALBuilt 1975 · S/N 31-7552042 N66CGPosada Raul Ignacion · El Paso, TXS/N 61P-0277-061 N66FRBledsoe James C · Hugo, COBuilt 2002 · S/N T18208107 N66JWNowell Borders Equipment G P Inc · Edinburg, TXBuilt 1972 · S/N 27-7304967 N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014 N66TSTall Timber Flying Service LLC · Kalispell, MTBuilt 2001 · S/N T20608334 N66WMTriple R & B Aviation LLC · Miami Beach, FLBuilt 1966 · S/N 32-40002 N66YCWatts Loren · Hermiston, ORBuilt 2005 · S/N 27-0344 N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035 N6708VAircraft Restoration Service Enhancements LLC · Mesa, AZBuilt 1970 · S/N 31011 N670MPStar Ground Services Inc · Tinian, MPBuilt 1971 · S/N 32-7140021 N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039 N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046 N6719LAwmr LLC · Conroe, TXBuilt 1969 · S/N 31-615 N6730YUrubek Raymond L · Refugio, TXS/N 27-4062 N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073 N674TCUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608380 N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079

Back to AD 81-12-06 R1