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.

N17HZLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 172-66345 N17JCHigh Wing Aviation LLC · Sardis, MSBuilt 1969 · S/N 164 N17KHHubatch Kenneth A · West Bend, WIBuilt 1991 · S/N 646-91 N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527 N17NSHalter Ernest J · Yorktown, INBuilt 1990 · S/N 24-1688-14 N17PMAiroyo Aviation LLC · Inlet Beach, FLBuilt 1987 · S/N 24-1618 N17RRRiverside Flight Center Inc · Tulsa, OKBuilt 1979 · S/N 15284134 N17SMN17sm LLC · Coral Springs, FLS/N 17272967 N17UPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1974 · S/N 17263440 N17WJAngel Wings Flyers LLC · Wilson, NCBuilt 1964 · S/N 2881 N1800RSugrue Aviation Inc · Silver City, SDBuilt 1978 · S/N R18200563 N18026Registered aircraftBuilt 1976 · S/N 17702525 N1802VWard Robert L Jr · Cleburne, TXBuilt 1974 · S/N 17263756 N18038Overton Asset Group LLC · St Marys, IABuilt 1976 · S/N 17702526 N1803GCarolina Aero Group LLC · Youngsville, NCBuilt 1968 · S/N 544 N1804GKrenzke Stephen E · Fairbanks, AKBuilt 1968 · S/N 100 N1805GWilliams Roger A · Langford, SDBuilt 1968 · S/N 559 N1806GAmelia Reid Aviation LLC · San Jose, CABuilt 1968 · S/N 573 N1806RFly By Night Aviation Inc · Pleasantville, NYBuilt 1978 · S/N R18200565 N1807GCj Mosman & Son · Nezperce, IDS/N 565 N1807RVeldman Richard D · Laporte, INBuilt 1978 · S/N R18200566 N1808GFleming Tod E · Davenport, WABuilt 1968 · S/N 570 N1809GBerardi Christopher · Crowley, TXBuilt 1968 · S/N 571 N180CGBailey Bendrix · Rochester, MABuilt 2002 · S/N 434-2002 N180KSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 17276467 N180LARonsman Harry M · Talkeetna, AKBuilt 1994 · S/N 368-94 N180NYN180ny LLC · Wainscott, NYBuilt 1978 · S/N 17271141 N180SDMoore Philip R · Thompsons Station, TNBuilt 1975 · S/N 219-76 N1810RMcdaniel Benjamin G III · Birmingham, ALBuilt 1978 · S/N R18200569 N1811GYelle Flyers LLC · Cashion, OKBuilt 1968 · S/N 584 N18129Loftics LLC · Kennewick, WABuilt 1976 · S/N 17702530 N1813GSenior Flyers LLC · Kalamazoo, MIBuilt 1968 · S/N 596 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N1817GJacelon Charles E · Little River, SCBuilt 1968 · S/N 409 N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217 N1817RLfg Properties LLC · Portage, MIS/N R18200571 N1818GPine Wind Aviation LLC · San Francisco, CABuilt 1968 · S/N 561 N1818PHansen Charles K · Roseburg, ORBuilt 1979 · S/N 24-0853 N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572 N1819DSpeedcraft Industries LLC · Port Jefferson, NYBuilt 2020 · S/N 1188-2020 N1819QSchmidt Mark · San Jose, CABuilt 1971 · S/N 177RG0219 N181RAPinkowski Richard · Marcellus, NYBuilt 1993 · S/N 719-93 N181TMEichhorn Scott William · Searcy, ARS/N 114-74 N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762 N18218All Spark Aviation LLC · Naples, FLBuilt 1978 · S/N R18200209 N1821QPamperien Casey Dean · Manassa, COBuilt 1971 · S/N 177RG0221 N18226Filler Joseph J · Wyoming, PABuilt 1976 · S/N 17702537

Back to AD 80-25-07 R1