Registered aircraft · 25,368

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.

N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239 N981SMMcintosh Steve A · Jefferson City, MOBuilt 1994 · S/N 24-3338 N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266 N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721 N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515 N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623 N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925 N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624 N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516 N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269 N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725 N98264Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276271 N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272 N9827CKae Aviation LLC · Conover, WIBuilt 1978 · S/N R18200449 N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727 N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625 N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928 N982GCollester Rodney D · Danville, INBuilt 1967 · S/N 7ECA-321 N982SKRowe Andrew L Jr · Hope, MEBuilt 1974 · S/N 17264042 N98306United States Air Force Owner · Usaf Academy, COBuilt 1985 · S/N 17276276 N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730 N9830VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264518 N9831GStarr David · Mount Prospect, ILBuilt 1979 · S/N 17273637 N98323Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276277 N98326Lum Barnett K · Temple City, CABuilt 1984 · S/N 17276278 N9833VMartin Kendall L · Wills Point, TXBuilt 1974 · S/N 17264521 N9834CN8184h LLC · Thiensville, WIBuilt 1978 · S/N R18200454 N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734 N9834LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276628 N98352Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276281 N98354Jin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276282 N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735 N9836BSoulek Paul A · Spearfish, SDBuilt 1982 · S/N 172RG1051 N9836CDominguez Robert R · Temecula, CABuilt 1978 · S/N R18200456 N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736 N9837GSouther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1974 · S/N 18801613T N9837LIal Corp · Wilmington, DEBuilt 1986 · S/N 17276629 N98381Central Air Parts Inc · Staunton, ILBuilt 1985 · S/N 17276284 N9838BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1052 N9838CWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200458 N9838GMcdonald James E · Harleyville, SCS/N 17259738 N9838HBaeder Mark A · Mesa, AZBuilt 1981 · S/N 18268059 N9838VWaypoint Equipment LLC · Mckinney, TXBuilt 1974 · S/N 17264524 N98395Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276285 N9839GLong William F · Belton, TXBuilt 1979 · S/N 17273638 N983VBKaufman Jeffrey Robert · Chapel Hill, NCBuilt 1978 · S/N R18200202 N98407Choice Aviation LLC · Hamilton, MTBuilt 1985 · S/N 17276287 N9840CMid Atlantic Ag LLC · Nassau, DEBuilt 1978 · S/N R18200460 N98410Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1984 · S/N 17276288 N9841GYoxall Jennifer S · Guilford, CTBuilt 1971 · S/N 17259741

Back to AD 80-25-07 R1