Registered aircraft · 25,370

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N549MAHinkle Airspray Inc · Cavalier, NDBuilt 2005 · S/N 1384-2005 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54CCScythe & Spade Co · Grand View, IDBuilt 1979 · S/N P21000360 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N54ERKhandpur Rajiv K · Hicksville, NYBuilt 1982 · S/N 24-1305 N54JMAviation Institute Of Maintenance · Virginia Beach, VABuilt 1968 · S/N 17257026 N54KHHertenstein Kevin Wayne · Lutz, FLBuilt 1979 · S/N 17272726 N54MMGwinn Roger A · Maple, NCBuilt 1979 · S/N 21063756 N54PRReimer Lynn C · Sioux Falls, SDBuilt 1972 · S/N 17260943 N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492 N54RAerometrix LLC · Lawrence, KSBuilt 1981 · S/N 21064514 N54RAAshlock Mark L · Loomis, CABuilt 1980 · S/N R18201684 N54VAFisheer Eric E · Memphis, TNBuilt 1968 · S/N 17257295 N54WDHat Creek Aviation LLC · Hamilton, MTBuilt 1981 · S/N R18201709 N5500CDuncan Robert L · Greenville, MSBuilt 1978 · S/N 401-78 N5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300 N5500LWinchell Lawrence R · Salem, NJBuilt 1978 · S/N 1032-78 N5500MDecathlon Training Inc · Saint Louis, MOBuilt 1978 · S/N 402-78 N5500WKansas State University · Salina, KSBuilt 1978 · S/N 432-78 N5501AProfly LLC · Wichita Falls, TXBuilt 1978 · S/N 360-78 N5501NRoddy Warren D · Skokie, ILBuilt 1978 · S/N 1034-78 N5502AAero Enterprises LLC · Orange, VABuilt 1978 · S/N 408-78 N5502CWebb Brad · Ekron, KYBuilt 1978 · S/N 1259-78 N5502HSky View LLC · De Smet, SDS/N 1035-78 N5502MRegistered aircraftBuilt 1978 · S/N 275-78 N5502QAcademy Computer Services Inc · Stoneham, MABuilt 1965 · S/N 604 N5502U90 Degree Crosswind LLC · Arcadia, FLBuilt 1978 · S/N 1260-78 N55034Osceola Aerosport LLC · Osceola, WIBuilt 1978 · S/N 420-78 N5503AKey Dallas T · Hoover, ALBuilt 1978 · S/N 411-78 N5503CMccreary William J · Glendale, AZBuilt 1978 · S/N 412-78 N5503HCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 413-78 N5503JFalterman Patrick J · Cleveland, TXBuilt 1978 · S/N 414-78 N5503QPrecious Metal Aviation LLC · Menomonee Falls, WIBuilt 1965 · S/N 2940 N5503VPurstell Kevin D · Burnt Hills, NYBuilt 1978 · S/N 1262-78 N5503YBundt Benjamin L · Montebello, CABuilt 1978 · S/N 418-78 N5504KWhite Traci Michelle · Manasquan, NJBuilt 1978 · S/N 1047-78 N5504NWighs Terry L · Fairbanks, AKBuilt 1978 · S/N 1264-78 N5504QDoll Electric Co Inc · Murphys, CABuilt 1965 · S/N 605 N5504SBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1978 · S/N 277-78 N5504YTarkington John W · Almyra, ARBuilt 1978 · S/N 423-78 N5505HKupferschmidt W Alan Trustee · Lake Elmo, MNBuilt 1978 · S/N 1038-78 N5505MCapozzi Eugene L · Kalispell, MTBuilt 1978 · S/N 424-78 N5505NMargolies Lars · Goldens Bridge, NYBuilt 1978 · S/N 1266-78 N5505QReynolds C J · Cornelius, NCBuilt 1965 · S/N 2941 N55065Lynch Timothy B · Aguadilla, PRBuilt 1978 · S/N 427-78 N55067Hinsch Delano G · Larchwood, IABuilt 1978 · S/N 428-78 N5506CBattle Creek Powersports LLC · Jasper, TNBuilt 1978 · S/N 1267-78 N5506HWoods George M · Anchorage, AKS/N 1240-78 N5506MCloud Kicker Aviation LLC · Kalamazoo, MIBuilt 1978 · S/N 1040-78 N5506ZOakcrest Management Inc · Brownsville, TXBuilt 1978 · S/N 364-78

Back to AD 80-25-07 R1