Skip to content

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.

N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194 N723PMCeu LLC · Greer, SCBuilt 1967 · S/N 28-4329 N723RVSmith Stuart T · Murrieta, CABuilt 1981 · S/N 727 N723SSmaltz David I · Newmanstown, PAS/N M-1384 N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153 N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940 N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577 N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073 N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262 N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578 N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075 N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407 N7242FDjair · Winchester, VAS/N 28-25155 N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942 N7242WSouthwest Fluid Products Inc · Weatherford, TXS/N 28-1065 N7243FBlack Diamond Real Estate · Roseville, CABuilt 1968 · S/N 28-25159 N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943 N7243JNova Flight LLC · Gainesville, VABuilt 1968 · S/N 28-24583 N7243VRobarge Chad Steven · Duluth, MNBuilt 1947 · S/N 123238 N7243WLejeune Ovey Eugene · Roanoke Rapids, NCBuilt 1963 · S/N 28-1066 N72448Clay Jason I · Imperial Beach, CABuilt 1957 · S/N 185841 N7244QBuckley Gregory L · Melba, IDS/N 17260544 N7245FLeinart Brannon B · Merit, TXBuilt 1968 · S/N 28-25161 N7245JKallen David A · Northville, NYBuilt 1968 · S/N 28-24586 N7246CValiair Limited Co Trustee · Casper, WYBuilt 1975 · S/N 28-7615048 N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946 N7246JCooper Christopher B · Crowley, TXBuilt 1968 · S/N 28-24587 N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546 N7247DTodey Mark A · Rathburn, IABuilt 1957 · S/N 22-5073 N7248DLeeuw Timothy P · Dillon, MTBuilt 1957 · S/N 22-5074 N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548 N72493Cook Tyler · Seldovia, AKBuilt 1975 · S/N 18775 N7249DHansen Larry G · Alliance, NEBuilt 1957 · S/N 22-5075 N7249FAndrews Josh S · Warsaw, MOBuilt 1968 · S/N 28-25166 N7249GTate Donald E · Jonesburg, MOBuilt 1970 · S/N 17258949 N7249JJohnson Dale F · Marion, INBuilt 1968 · S/N 28-24591 N7249PDavis Scott · Bingham, NEBuilt 1960 · S/N 24-2425 N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549 N724CASouth Shore Flying Club Inc · South Weymouth, MABuilt 1999 · S/N 2843224 N724CFGallagher Timothy N Trustee · Pagosa Springs, COS/N 724 N724CWFlynn Grady Collin · Loudon, TNBuilt 2005 · S/N 90683 N724DPJefferson Devin S · Sandia, TXBuilt 1996 · S/N 1299 N724FLUncle Tommy LLC · Aurora, ILBuilt 1972 · S/N 28-7225417 N724GAWilliams John D · Geneva, OHS/N GA7-0023 N724JMTygielski Brent R · Clarkston, MIBuilt 1963 · S/N 2502 N724LPBone Aviation LLC · Calhoun, GABuilt 1968 · S/N 28-4962 N724RStardust Aviation LLC · Farmingdale, NYBuilt 2003 · S/N 2843543 N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971 N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381 N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869

Back to AD 80-04-03 R2