Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N904WRRhr Equipment Leasing LLC · Alpharetta, GABuilt 1977 · S/N 32R7780172 N9050KFender Jason · Jacksonville, ARBuilt 1977 · S/N 28R-7803060 N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515 N9051PFerris Tyler S · Pompano Beach, FLBuilt 1966 · S/N 24-4516 N9051VWhite Air Ltd · Dover, DEBuilt 1977 · S/N 28R-7703334 N9052PVentura Alejandro · Lakeside, CABuilt 1966 · S/N 24-4518 N9053KBrown Aero Technologies LLC · Alexander City, ALBuilt 1977 · S/N 34-7870035 N9053POhlstein Michael R · Glen Head, NYBuilt 1966 · S/N 24-4519 N9055PB Dot Air LLC · Jackson, WYBuilt 1966 · S/N 24-4521 N9056PMarion Brian R · Denver City, TXBuilt 1966 · S/N 24-4522 N9057PLambert Dwight E · Albany, ORBuilt 1966 · S/N 24-4523 N9061PLangley Preston B · Warwick, NDBuilt 1966 · S/N 24-4528 N9063PDavis Clyde Jackson Jr Trustee · Tehachapi, CABuilt 1966 · S/N 24-4530 N9065POdenbach Eric J · Eureka, SDBuilt 1966 · S/N 24-4533 N9067PMahathey Tony C · Colorado Springs, COBuilt 1966 · S/N 24-4535 N9069PGeer James Benjamin · Olympia, WABuilt 1966 · S/N 24-4537 N906KEDaniel Tayja · Brooklyn, NYS/N 28R-35631 N906QKVilla Aircraft Maintenance Inc · Fort Lauderdale, FLBuilt 1977 · S/N 34-7770309 N9070PWilliamson Paul H · Carrollton, TXS/N 24-4538 N9074PNickell Jon B · North Platte, NEBuilt 1966 · S/N 24-4543 N9075PKovacevich Nicholas P · Jackson, CABuilt 1966 · S/N 24-4544 N9077PFarris James E · Brentwood, TNFirst renewal noticeBuilt 1966 · S/N 24-4546 N9079PTyrrel David E · Harlan, IABuilt 1966 · S/N 24-4549 N907LJAgl Aero LLC · Mckinney, TXBuilt 1969 · S/N 30-1862 N9081PTriple J Aviation LLC · Turlock, CABuilt 1966 · S/N 24-4551 N9082PAmeneyro David · Walla Walla, WABuilt 1966 · S/N 24-4552 N9083PRowland Blayne Administrator · Raymondville, TXBuilt 1966 · S/N 24-4553 N9084PSchafer Timothy M · Ridgefield, CTBuilt 1966 · S/N 24-4555 N9085PCross Seth B · Whitewood, SDS/N 24-4556 N9086PRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 1966 · S/N 24-4557 N9089PDummer Donald W · Novato, CABuilt 1966 · S/N 24-4563 N908KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 34-7970060 N9090PCatherwood Owen · Eugene, ORBuilt 1966 · S/N 24-4564 N9091PGalagan Robert · Lincoln Park, NJBuilt 1966 · S/N 24-4565 N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197 N9096PGoodman Kenneth M · Eastpoint, FLBuilt 1966 · S/N 24-4572 N9097PA T Aviation LLC · Cherokee, IABuilt 1966 · S/N 24-4573 N9099KWallace Jacob M · Central Point, ORBuilt 1977 · S/N 28R-7837028 N909RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 34-7770069 N90FEPasley Michael Cole · Niceville, FLBuilt 1969 · S/N 28R-35121 N90MHMooers Michael T · Hagerstown, MDBuilt 1976 · S/N 28R-7635158 N90VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 24-4926 N9100PYoder Ernie · Bristol, INBuilt 1966 · S/N 24-4576 N9102KM & T Aircraft LLC · North Canton, OHBuilt 1977 · S/N 28R-7837029 N9102PFrandsen Brian L · Riverton, UTBuilt 1966 · S/N 24-4578 N9103PCarnahan Pamela S · Deer Trail, COBuilt 1966 · S/N 24-4579 N9106PMiller Jerry L · Garrison, NDBuilt 1966 · S/N 24-4583 N9107PLeigh Malik · Pompano Beach, FLBuilt 1966 · S/N 24-4584 N9108KHicks William A Jr · Mount Airy, NCBuilt 1977 · S/N 32R-7880032 N9109PPondo Inc · Wilmington, DEBuilt 1966 · S/N 24-4587

Back to AD 97-01-01 R1