Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N423RCConcord Trailer World Inc · Concord, CABuilt 2019 · S/N T20609592 N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606 N424BHTouchdown Arkansas LLC · Batesville, ARBuilt 1976 · S/N 32R-7780016 N424DN424d LLC · Naples, FLBuilt 2024 · S/N T18209162 N424EKDeland Air And Sea Brokerage Inc · Deland, FLBuilt 2009 · S/N T18208981 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 N4258FGoldfinch LLC · New York, NYBuilt 2024 · S/N T18209135 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 N427AMState Of Oregon · Salem, ORBuilt 2010 · S/N T18209018 N427APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N T18209019 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

Back to AD 71-13-01 R1