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.

N423JTSoutheast Air Tran LLC · Hahira, GABuilt 1994 · S/N 4622162 N423PSTabano Anthony · National Harbor, MDBuilt 2004 · S/N 27-0326 N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016 N424FARobinson Todd Allen · San Luis Obispo, CABuilt 2003 · S/N T20608424 N424PAviation Co LLC · Kaneohe, HIBuilt 1974 · S/N 31-7401222 N424RMEast End Grill Management Co LLC · Memphis, TNBuilt 1977 · S/N 32R-7780306 N424SBBsi Technologies II Inc · Richmond, VABuilt 1999 · S/N 27-0280 N424TPHarris Joseph · Bradenton, FLBuilt 1977 · S/N 32R-7780332 N424WHSchmidt Richard A · West Linn, ORBuilt 2004 · S/N T18208294 N4250RNewsome George W III · Palmyra, NYBuilt 1969 · S/N 32-40617 N4254RStar Marianas Air Inc · Saipan, MPBuilt 1969 · S/N 32-40625 N4259RThorn Robert L · Clovis, NMBuilt 1969 · S/N 32-40631 N425CAHowell Norman · Port Orange, FLBuilt 1977 · S/N 61P-0425-156 N4260RColin Irons Diving And Pool Service · Crawfordville, FLBuilt 1969 · S/N 32-40634 N4262RKirkpatrick Alan E · Oklahoma City, OKS/N 32-40636 N4264AReed William B · Cortlandt Manor, NYBuilt 1947 · S/N NAV-4-606 N4266RBig Guy Enterprise Transportation LLC · Portland, ORBuilt 1969 · S/N 32-40639 N426PRRyka Aviation LLC · Sunrise Beach, MOBuilt 1999 · S/N 3257108 N426SSale Reported · Kotzebue, AKSale reportedS/N 31-8152190 N426SEAthena Aviation LLC · Golden, MSS/N 3255042 N426TC3di LLC · Elizabeth, WVBuilt 1987 · S/N 4622001 N4270RKreiser Foster E Jr · Middletown, PABuilt 1969 · S/N 32-40645 N4270TAllen Aero LLC · Saint Cloud, FLBuilt 1971 · S/N 32-7240048 N4272RModic David J · Escondido, CABuilt 1969 · S/N 32-40647 N4277RFoxtrot Golf LLC · Kalispell, MTBuilt 1969 · S/N 32-40648 N4279RCummins Dan D · Blencoe, IABuilt 1969 · S/N 32-40651 N427ABSouthern Fabrication & Welding LLC · El Dorado, ARS/N 4636324 N427JKMoore J R · Montgomery, TXBuilt 1997 · S/N 3246061 N427WSMijares Miguel · Mcallen, TXBuilt 2001 · S/N 4636321 N4280RRupp Amanda E · Osteen, FLBuilt 1969 · S/N 32-40653 N4289RShaughnessy Paul V Jr · Norwood, MABuilt 1969 · S/N 32-40665 N428RAN428ra LLC · Hampshire, ILFirst renewal noticeBuilt 1978 · S/N 32R-7887121 N4290RLadet David E · Lavonia, GABuilt 1969 · S/N 32-40666 N4292RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 32-40669 N4292SD&D Design Manufacturing Inc · Oklahoma City, OKBuilt 1983 · S/N 32R-8329014 N4293RLaws Chris · Mckenzie, TNS/N 32-40671 N4294PAex Enterprises LLC · Alexandria, LABuilt 1983 · S/N 32R-8329015 N4296RJohnstone Colin · Enterprise, ALS/N 32-40674 N4296TD'Haem Christopher M · East Lansing, MIBuilt 1983 · S/N 32-8324009 N4296XWilco Consulting LLC · Elkhart Lake, WIBuilt 1983 · S/N 32-8324010 N42979Dashanddash LLC · Athens, GABuilt 1983 · S/N 32R-8329021 N4297CEv Aviation LLC · Elizabeth, COBuilt 1983 · S/N 32R-8329019 N4297R4297 Romeo Aviation LLC · Owasso, OKBuilt 1969 · S/N 32-40675 N4298RAv79 Aviation LLC · Dover, OHBuilt 1969 · S/N 32-40677 N4299RRimlinger Timothy Trustee · Audubon, PABuilt 1969 · S/N 32-40678 N4299XFerguson Teresa · Houston, ARBuilt 1983 · S/N 32-8324012 N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54 N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695 N42CXSilver Hawks Ltd · Columbus, OHBuilt 1973 · S/N 32-7340142

Back to AD 81-12-06 R1