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.

N4131WRudd Joshua A · Cresson, TXBuilt 1967 · S/N 32-40197 N4132WTopken William F · Fallon, NVBuilt 1967 · S/N 32-40198 N41335Doherty Gordon W Jr · Garden Plain, KSBuilt 1974 · S/N 32-7440083 N4133GAmsg Transport LLC · Bloomfield Hills, MIBuilt 1998 · S/N 4636186 N4133RFlying Friends LLC · Lynchburg, VABuilt 1968 · S/N 32-40450 N4133WHochstedler Wilford L · Parsons, KSBuilt 1967 · S/N 32-40199 N4134BWildrose Aviation LLC · Victor, CABuilt 1974 · S/N 74-31102 N4134DScull Timber Co Inc · Tenaha, TXBuilt 1998 · S/N 3257070 N4135QRegistration Pending · Lenoir City, TNRegistration pendingBuilt 1977 · S/N 32R-7780329 N4135RHinkle Robert J · Caldwell, IDBuilt 1968 · S/N 32-40452 N41365Henke Cory William · Rosendale, WIBuilt 1974 · S/N 32-7440086 N4136FBeising Steven E · Las Vegas, NVBuilt 1976 · S/N 32R-7680429 N4136RRobinson Douglas A · Derry, NHBuilt 1968 · S/N 32-40492 N4136SCrass David B · Aledo, TXBuilt 1999 · S/N 3257093 N4137FMcabee Patrick A · Tampa, FLBuilt 1976 · S/N 32R-7680430 N4137PGreene Marble & Granite Co · Manalapan, NJBuilt 1999 · S/N 3257086 N4137RDavis Charles E · Mount Dora, FLBuilt 1968 · S/N 32-40455 N4138RReece Doyle · Bentonville, ARBuilt 1968 · S/N 32-40493 N4139SKdj LLC · Wilmington, DEBuilt 1999 · S/N 3257099 N4139TMalibu Mirage Inc · Eugene, ORFirst renewal noticeBuilt 1998 · S/N 4636179 N4139VBourgogne Aviation Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 3257085 N413HCNeed For Speed LLC · Tyler, TXS/N 32R-8429012 N413TCMcbeath Casey A · Shreveport, LABuilt 2005 · S/N T18208423 N41408Drixhurst Six LLC · Lindon, UTBuilt 1974 · S/N 32-7440088 N4140RStewart Mike F · Chugiak, AKBuilt 1968 · S/N 32-40459 N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160 N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233 N4141RHard Landing LLC · Fort Pierce, FLS/N 32-40460 N4142WDale Mike S · Boise, IDBuilt 1967 · S/N 32-40210 N4143RCon Air Aviation LLC · Borger, TXBuilt 1968 · S/N 32-40462 N4144RRacer Investments LLC · Long Beach, CAS/N 32-40463 N41469Shield Solutions LLC · West Plains, MOBuilt 2000 · S/N 3257154 N4146PN4146p Saratoga LLC · Austin, TXBuilt 1999 · S/N 3257106 N4147RRamos George L · Conroe, TXBuilt 1968 · S/N 32-40347 N4147WRalls Michael Todd · Crawfordsville, IABuilt 1967 · S/N 32-40217 N41492Charter Air Travel LLC · Mount Pleasant, SCBuilt 1999 · S/N 3257105 N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226 N414LBRegistered aircraftBuilt 1979 · S/N 14524 N4150WMathews Brandon · Eunice, NMS/N 32-40221 N41518Lechene Craig · Holly Springs, NCBuilt 2000 · S/N 46-36302 N4151BCraig Scott W · Sorento, ILBuilt 1974 · S/N 75-32-152 N4151PDaman Arthur C Trustee · Arroyo Grande, CABuilt 2000 · S/N 3257188 N4151RMartin Michael T · Las Vegas, NVBuilt 1968 · S/N 32-40465 N4152DSires Brian · Cedar Falls, IABuilt 2000 · S/N 46-36304 N41545Faulks Carson · Wellington, TXS/N 32-7440097 N4157EBel Air LLC · Henderson, KYBuilt 1984 · S/N 31P-8414047 N4159RArmstrong Scott T · Navasota, TXBuilt 1968 · S/N 32-40474 N4159WNorthern Sky Aviation LLC · Howard Lake, MNBuilt 1967 · S/N 32-40231 N415SAArtemis Aviation Group LLC · Kalispell, MTBuilt 1954 · S/N 14064 N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290

Back to AD 81-12-06 R1