Registered aircraft · 25,369

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.

N7695SState Of Alaska · Fairbanks, AKBuilt 1976 · S/N 225-76 N7697GFlight School Inc · Spring, TXBuilt 1970 · S/N 17259397 N7697SKenley Fredrick Charles · Palmer, AKBuilt 1976 · S/N 226-76 N7699GZhao He · Yaphank, NYBuilt 1970 · S/N 17259399 N769JBGibson Randy L · Clinton, TNBuilt 1968 · S/N 17257380 N769NERegistration Pending · Pottstown, PARegistration pendingBuilt 1977 · S/N 15280893 N76AGSkyview Applicators LLC · Hartington, NEBuilt 1976 · S/N 18802699T N76BCYackley Ranches · Onida, SDBuilt 2020 · S/N 606-2020 N76BEBrown Darrell W · Covington, GABuilt 1969 · S/N 168 N76CMRegistration Pending · New Braunfels, TXRegistration pendingBuilt 1978 · S/N 38-78A0422 N76DESchiff Brian · Keller, TXS/N 513-2007 N76DRAppleget Edward L · Glendale, AZS/N 22-1348 N76EPFlorida Health Privilege LLC · Key West, FLBuilt 1998 · S/N 24-3425 N76GLSullivan Vincent E · Centerville, IABuilt 1976 · S/N 0736 N76HJAmalong Timothy M · Tucson, AZBuilt 1976 · S/N 17266809 N76HPDavid Ingram Security Solutions · Lander, WYBuilt 1970 · S/N 700010 N76HSDelgrosso Dennis W · Saranac, NYBuilt 1977 · S/N 17702642 N76JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1974 · S/N 17263122 N76JKKrajewski Jason · Portland, ORBuilt 1976 · S/N 177-02435 N76KFRegistration Pending · Grenada, MSRegistration pendingBuilt 1974 · S/N 153-74 N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925 N76MLDunn Courtland E Jr · West Grove, PABuilt 1974 · S/N 446-74 N76PPGround Effect Aviation LLC · Ogden, UTBuilt 2007 · S/N 494-2007 N76SMCasey Mike P · Whitefish, MTS/N 393-72 N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711 N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025 N76YDBeasley Charles A · Spencer, VABuilt 1975 · S/N 199-75 N7700MWood Duck Loop LLC · Mooresville, NCBuilt 1967 · S/N 670118 N7701MHurt Roy DBA · Newark, OHBuilt 1967 · S/N 670119 N7702MCullen William Edward · Mill Valley, CABuilt 1967 · S/N 670120 N7702VBrown Warren C · Pasadena, CABuilt 1976 · S/N 177RG0905 N7704MCollins Benjamin N · Chapel Hill, NCBuilt 1967 · S/N 670137 N7704SHolte Bruce C · Thief River Falls, MNBuilt 1976 · S/N 1172-76 N770ACSearching For Grass LLC · Stroudsburg, PAS/N 380-96 N770CMMooney Blues Aviators Inc · Naples, FLBuilt 1998 · S/N 24-3416 N770DKStanton Michael · Wilmington, NCBuilt 1967 · S/N 670121 N770DTBargemann Jeffrey Karl · Greenville, OHS/N 24-0337 N7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeS/N P21000072 N7712JChapman James A · San Antonio, TXBuilt 1966 · S/N 3434 N7713GDavenport Jimmy J · Hayesville, NCS/N 17259413 N7714GGlynco Manning Aviation Inc · Brunswick, GABuilt 1970 · S/N 17259414 N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415 N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416 N77177Nazario Caleb R · Orlando, FLBuilt 1977 · S/N 177RG1118 N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417 N771ACMorrison William Fraser · Bonners Ferry, IDS/N 379-96 N771CTCrump John · Gillette, WYBuilt 2006 · S/N 1407-2006 N771JNSteiner Martin A · Bellaire, OHS/N 680041 N771LLBravo November LLC · Wilsonville, ORBuilt 2008 · S/N 1065-2008 N771MRSmith Nathan · Palmer, AKBuilt 1967 · S/N 87

Back to AD 80-25-07 R1