Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N721DLFour Stars Aviation LLC · Mckinney, TXBuilt 2003 · S/N 2254 N721ETHummel Alan Jay · Indianola, IABuilt 2001 · S/N 20409 N721HHHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1990 · S/N 1484 N721JFTiger Moon LLC · Portland, ORBuilt 1978 · S/N AA5B0807 N721JKMcdaniel Hardey I · Marion, INBuilt 1996 · S/N 164 N721JWBlue Water Aviation Inc · Jupiter, FLBuilt 1989 · S/N 1809015 N721LPN721lp LLC · Gainesville, GABuilt 1966 · S/N 670009 N721PStobbe Marlin L · Granada Hills, CABuilt 2004 · S/N 33009C N721RJGenes Helicopter Leasing LLC · Durham, MEFirst renewal noticeBuilt 1998 · S/N 2860 N721RTAbbott R Barry · Sterling, AKBuilt 1968 · S/N M-1170 N721SMBlue Skies Flying Services Inc · Lake In The Hills, ILBuilt 2000 · S/N 2843337 N7220FSmith Craig D · Lucedale, MSBuilt 1968 · S/N 28-25131 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7220RReidenbach John S · Kenosha, WIBuilt 1997 · S/N 2682 N7221CPtg LLC · Princeton Junction, NJBuilt 1975 · S/N 28-7615047 N7221JWilliams Maria M · Kernersville, NCBuilt 1968 · S/N 28-24557 N7221PBuhrmeister Timothy J · Centereach, NYBuilt 1960 · S/N 24-2393 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N7222JAviation Partners Llp · Bismarck, NDBuilt 1968 · S/N 28-24558 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7223DTonelli James D R · Locust Grove, GABuilt 1957 · S/N 22-5048 N7223FBrown Richard G · Irvine, CABuilt 1976 · S/N 28-7725087 N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523 N7223WRajuan Oren · Sacramento, CAFirst renewal noticeBuilt 1963 · S/N 28-1038 N7224DBank Jeffrey J · Littleton, COBuilt 1957 · S/N 22-5049 N7224FBiviano Joseph J · Tehachapi, CAS/N 28-25136 N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925 N7225VConnecticut Aircraft Sales LLC · Manchester, CTBuilt 1977 · S/N 17270030 N7225WOshaughnessy Breandan · Allen, TXBuilt 1963 · S/N 28-1041 N7226DAdams Andrew V · Joplin, MOS/N 22-5747 N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926 N7226JChristffersen Robert H · Tacoma, WABuilt 1968 · S/N 28-24562 N7226WStuart Ryan C · Snowflake, AZBuilt 1963 · S/N 28-1143 N7227DRobinson Eric C · Palmer, AKBuilt 1957 · S/N 22-5052 N7227FStrange Keith · Lincoln, MEBuilt 1968 · S/N 28-25139 N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927 N7227JRad Aviation LLC · Abbeville, ALS/N 28-24563 N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527 N7228DAmigo Helicopter Services LLC · Falfurrias, TXS/N 3725 N7228GFasking Dan · Stanford, ILS/N 17258928 N7228JRedhanded LLC · Dover, DEBuilt 1968 · S/N 28-24564 N7228ZHart Samuel C Jr · Newberry, SCBuilt 1997 · S/N 21907 N7229DBuergel Sandra J · East Aurora, NYBuilt 1957 · S/N 22-5054 N7229JLivingston Corey · Myrtle Beach, SCBuilt 1968 · S/N 28-24565 N7229NMccracken Donald D · Keyport, WABuilt 1999 · S/N 422REB N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529 N7229WRoll The Bones LLC · Kiln, MSBuilt 1963 · S/N 28-1046 N722AARobinson Charles F Jr · Portage, MIBuilt 1972 · S/N 17261274 N722CSBoccaccio Peter Anthony · Burke, SDBuilt 1962 · S/N 2171 N722DCHiemstra Andrew Ralph Walter · Tuolumne, CAS/N 001DC

Back to AD 80-04-03 R2