Skip to content

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

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.

N2463LBivens Kennett A · Spanaway, WABuilt 1979 · S/N 38-79A0709 N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292 N2466BFoecking James · Valley City, OHS/N 38-79A0073 N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293 N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294 N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391 N2468NSouth Texas Air Force LLC · Mission, TXBuilt 1979 · S/N 38-79A0858 N2468WGodwin Gerald · Orange, TXS/N 886-2001 N2469KPilot Ready LLC · Lime Springs, IABuilt 1979 · S/N 38-79A0654 N246ATBorghi Eric C · Leonia, NJBuilt 1989 · S/N 24-3121 N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752 N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355 N246JCSchultes James F Jr · Woodbury, NJBuilt 1985 · S/N 24-1557 N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535 N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91 N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005 N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003 N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023 N246TFMorgan Daniel D · Topeka, KSS/N R18201677 N24704Blumer Charles · Fullerton, CAS/N 38-78A0785 N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332 N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334 N24718Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0002 N2471EWilliams Stephen H · Phoenix, AZBuilt 1982 · S/N 18268206 N2471LGuzman Gerald F · Winchester, CABuilt 1979 · S/N 38-79A0712 N2471NTwo Dot Aircraft LLC · Kalispell, MTBuilt 1979 · S/N 38-79A0859 N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341 N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969 N2472NVann Dudley C DBA · Greenville, NCBuilt 1979 · S/N 38-79A0860 N2472VColthirst Michael · Clarksville, TNBuilt 1982 · S/N 38-82A0064 N2473KGondringer Steve M · Trenton, MOS/N 38-79A0655 N2473NKline Glenn A · Iron River, MIBuilt 1979 · S/N 38-79A0861 N2474BLetourneau University · Longview, TXBuilt 1978 · S/N 38-79A0078 N2474EBas Part Sales LLC · Greeley, COS/N 17271297 N2474FCoke Roger T · Clarksville, INFirst renewal noticeBuilt 1979 · S/N 38-79A0468 N2474GSchwartz Theodore Francis · Fogelsville, PABuilt 1979 · S/N 38-79A0541 N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355 N2475TDurban George E · Indianola, IABuilt 1978 · S/N 38-78A0812 N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361 N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362 N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363 N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364 N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365 N2476GSouthern Region Machine Service Inc · Castlewood, VABuilt 1979 · S/N 38-79A0542 N2476NHart Lewis W DBA · Rexburg, IDBuilt 1979 · S/N 38-79A0862 N24773Grusy Norman D · Portland, ORS/N 15280369 N24775Cal Aggie Flying Farmers Inc · Davis, CABuilt 1977 · S/N 15280371 N2477KKing Mike · Corpus Christi, TXBuilt 1979 · S/N 38-79A0657 N24781Shaw Erin · Reno, NVBuilt 1977 · S/N 15280375 N2479KAllison Larry J · Villa Rica, GAS/N 38-79A0659

Back to AD 80-25-07 R1