Registered aircraft · 40,473

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N52635Allard Michael · Penrose, COS/N 17274573 N5263BFerland Erik · Everett, MABuilt 1957 · S/N 1126 N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561 N5263WCjco Holdings LLC · Venus, TXBuilt 1962 · S/N 28-309 N5264DPironti Bennett D · Long Valley, NJS/N 17272481 N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036 N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310 N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170 N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576 N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482 N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804 N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479 N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311 N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124 N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483 N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805 N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037 N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312 N5266WMichigan Sport Aviators Inc · Midland, MIBuilt 1962 · S/N 28-312 N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191 N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577 N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806 N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565 N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303 N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579 N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580 N5268BCabbage David A · Colville, WABuilt 1957 · S/N 1131 N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389 N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751 N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038 N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482 N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252 N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567 N5269TKailua Aviation LLC · Moorestown, NJBuilt 1972 · S/N 28-7205253 N5269WGoetz David B · Gleason, WIS/N 28-315 N526ECChapman Daniel W · Soldotna, AKBuilt 1986 · S/N 1689 N526FRoush Heith · Cabot, ARS/N 17700932 N526KGWalters David M · Wasilla, AKS/N 18-4294 N526PDDecraene Peter R · Shorewood, ILBuilt 2004 · S/N 70369 N526WPPickering Gordon D · La Pine, ORBuilt 2020 · S/N 441 N526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLS/N 17269371 N52700Air Transport Inc DBA · Las Vegas, NVS/N 17274583 N52702Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274585 N5270HR & D Aircraft Inc · Jamestown, NCBuilt 1975 · S/N 17265390 N5271LBright Skies Sales And Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-4569 N5271RAyala-Moore Kristopher · Tucson, AZBuilt 1974 · S/N 17263485 N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316 N5271WBrown Thrasher Aero LLC · Midland, GABuilt 1962 · S/N 28-317 N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196 N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592

Back to AD 80-04-03 R2