AD 80-25-07 R1

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
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.

N5536QWokini Air LLC · Tarpon Springs, FLS/N 621N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785N5537HLine Michael · University Park, MDBuilt 1979 · S/N 15284121N5537KSales First LLC · Jasper, GABuilt 1978 · S/N 392-78N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073N5537SMcpeak Alan W · Colorado Springs, COBuilt 1980 · S/N R18201600N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78N5538QDurkee Brenton J · Brooklyn, NYBuilt 1965 · S/N 622N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958N5539TPattison Aero Inc · Henderson, NVS/N R18201889N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247N55404Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17275175N55409Burrowes William A · Springfield, OHS/N 17275176N5540KTymczyszyn William R · Torrance, CABuilt 1978 · S/N 394-78N55420M A R S Aircraft Leasing LLC · Williamsburg, VABuilt 1981 · S/N 17275177N55422Boardman Thomas M · Greenwich, NYS/N 17275178N5543EMedina Kevin S · Glendale, CABuilt 1978 · S/N 17271886N5543KClassic Aviation LLC · Richmond, MIBuilt 1978 · S/N 1256-78N5544KZollars Thomas B · Dallas, TXBuilt 1978 · S/N 396-78N5544LRegistration Pending · Troy, NYRegistration pendingBuilt 1980 · S/N 15284347N5544SLobitz James R Co Trustee · Oak Park, CABuilt 1980 · S/N R18201603N5544TPercario Joseph · Warren, NJBuilt 1982 · S/N R18201893N55457Legend Air Lease LLC · Hurricane, UTBuilt 1981 · S/N 17275184N5545KSchroder Bernd · Brownsville, CABuilt 1978 · S/N 1031-78N5545QVan Wagner Paul A · Waterford, PABuilt 1965 · S/N 2961N5545SLareve Air LLC · Bloomfield, MIBuilt 1980 · S/N R18201604N5545TMoody Bible Institute Of Chicago · Spokane, WABuilt 1982 · S/N R18201894N5546HMoore Thomas P · Basalt, COBuilt 1981 · S/N 18267873N5546JRegistration Pending · Danbury, CTRegistration pendingS/N 17273816N5546QBrant Ryan L · Meyersdale, PAS/N 626N5546RGorn Joel · Lawrence, MABuilt 1979 · S/N 172RG0075N5546SChoice Vc LLC · Oakland, MIBuilt 1980 · S/N R18201605N5547QMooney N5547q LLC · Sacramento, CABuilt 1965 · S/N 2962N55482Crook Mark E · Elberton, GABuilt 1981 · S/N 17275193N5548LUnruly Passengers LLC · Piedmont, SCBuilt 1980 · S/N 15284350N5548SGardner Timothy J · Gardnerville, NVS/N R18201606N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491N5549NRfd Aero LLC · Wilsonville, ORBuilt 1980 · S/N 18267784N5549SArdizzone Mark Robert · Mckinney, TXS/N R18201607N554DKRvest Management LLC · Boulder City, NVS/N 502-2007N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818N5550QReal Jonathan Dan · La Jolla, CABuilt 1965 · S/N 628N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195N5551KSchlamer Robert B · Hernando, FLBuilt 1978 · S/N 400-78N5551LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284353
Back to AD 80-25-07 R1