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.

N4547FSky Pilot Aviation Corp · Carlsbad, CABuilt 1976 · S/N 28-7790042 N4547RYeattes Michael K · Emporia, VABuilt 1965 · S/N 28-21253 N4548APue Thomas A · Marshfield, WIBuilt 1956 · S/N 22-3857 N4549RHamburg Airport 1 LLC · Williamsville, NYBuilt 1965 · S/N 28-21255 N4549YAbbott Christopher J · Gordon, NEBuilt 1971 · S/N 18-8937 N454ASHammond Helicopter LLC · Nephi, UTS/N 2260 N454BMCorman David L · Lovington, ILBuilt 1972 · S/N 17260799 N454CFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1967 · S/N 28-23412 N454GLZelsnack Anthony · Mc Graw, NYS/N 1156 N454MDRegistration Pending · Bulverde, TXRegistration pendingBuilt 1966 · S/N 28-3125 N454QTwin Buttes Ranch Inc · Shawnee, WYBuilt 1956 · S/N 18-4902 N454WCNielsen Kai V · Arlington, WABuilt 1959 · S/N 1397 N454WWTate Larry J · Mountain Home, ARBuilt 2001 · S/N 22988 N454WYBrongworx LLC · Ballwin, MOBuilt 2009 · S/N 005 N454XThree Wing Flight School LLC · Stratford, CTBuilt 1978 · S/N 28-7890318 N45502Sims Hal Christopher · Colleyville, TXBuilt 1979 · S/N AA5B1190 N4550DCharlymark 7 Flight Club LLC · Jamaica, NYBuilt 1983 · S/N 28-8390041 N4550EPommy & Swede LLC · Valentine, NEBuilt 1978 · S/N 17271628 N4550XAltitude LLC · Madison, WIBuilt 1975 · S/N 28-7625053 N4551FViser Timothy A · Cleveland, TNBuilt 1976 · S/N 28-7790044 N4552AHall Mark R · New Smyrna Beach, FLBuilt 1956 · S/N 22-3862 N4553UCoyle Jonathan D · Franktown, COBuilt 1964 · S/N 15060553 N4554BWoodrum Steven E · Fort Wayne, INBuilt 1979 · S/N AA5B1183 N4554TGlazer Aviation LLC · Owings Mills, MDBuilt 1972 · S/N 28-7205184 N4554XSchwartz Michael · Bethel, CTBuilt 1975 · S/N 28-7690035 N45552Aerospace Trust Management LLC Trustee · Wilmington, DES/N 18-8563 N4555ALifetime Adventures LLC · Bellevue, MIBuilt 1956 · S/N 22-3866 N4555REagle Aeronautical Company LLC · Dover, DEBuilt 1965 · S/N 28-21294 N4556AScott Brent A · Fulton, MOS/N 22-3867 N4556BStrotkamp Timothy B · Sugar Land, TXBuilt 1979 · S/N AA5B1222 N4557ABuskey Walter B · Etna, NHBuilt 1956 · S/N 22-3868 N4557RThomson James A · Boron, CABuilt 1965 · S/N 28-21298 N4557SJustus Gary R · Evergreen, COBuilt 1979 · S/N AA5B1235 N4557TWomack Associates LLC · Lancaster, KYBuilt 1972 · S/N 28-7225188 N4557YPogany Stone C · Anchorage, AKBuilt 1971 · S/N 18-8938 N4558ESmith Gregory W · Weirsdale, FLS/N AA5B1239 N4558HTjr Inc · Bellevue, NEBuilt 1979 · S/N 24-0765 N4558RMorgan Chad A · Sarepta, LABuilt 1965 · S/N 28-21300 N4559AKsm Aviation LLC · Kalispell, MTS/N AA5B1245 N4559BSpencer Douglas L · Lexington, GABuilt 1979 · S/N AA5B1246 N4559LAirtime Aviation Inc · Tulsa, OKBuilt 1979 · S/N AA5B1247 N4559RCavu Flight LLC · Simpsonville, SCS/N 28-21301 N4559TLeek Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7205185 N455ADMoghis Edgar C · Redwood City, CAS/N 316 N455AFGlacier Bay Aviation LLC · Fayetteville, GABuilt 1968 · S/N 17701336 N455DDBailey Steven S · Ottawa, KSBuilt 1995 · S/N 21455 N455FLFisher Jeffrey D · Omaha, NEBuilt 1971 · S/N 28-7125250 N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393 N455JIsler Jerry L · Donalsonville, GABuilt 2007 · S/N 1070 N455RTSouthern Genesis Aero LLC · Midland City, ALBuilt 2000 · S/N 447-2000

Back to AD 80-04-03 R2