Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653 N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724 N5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449 N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840 N56545Sauder Richard J · Evergreen, COBuilt 1984 · S/N 8040C N56547Schroeder Gordon D · New Braunfels, TXBuilt 1984 · S/N 8055C N5654BStol-Air LLC · Salem, ORFirst renewal noticeBuilt 1984 · S/N 8035C N5654DMiller Arlyn E · Boise, IDBuilt 1984 · S/N 8038C N5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725 N5654URoss Michael M Trustee · Anchorage, AKBuilt 1984 · S/N 8043C N5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190 N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815 N5655Phillips Mark E · Williamsville, ILS/N 28-3720 N56550Holmes Peter L · Erieville, NYBuilt 1984 · S/N 8056C N56558Onlyfly LLC · Deltona, FLS/N 28-7425004 N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017 N5655QJamil Mohammad Mahbub · Stockton, CABuilt 1965 · S/N 3026 N5655RKavalieros James A · Bridgewater, NJBuilt 1984 · S/N 8049C N5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913 N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727 N5656WBennett Steven D · Durham, NCS/N 28-821 N5656YD & D Airpark LLC · Anchorage, AKBuilt 1965 · S/N 18-8290 N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019 N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661 N5657QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1965 · S/N 3027 N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287 N5657SMelton Ricky N · Luttrell, TNBuilt 1984 · S/N 8054C N5657WMacdonald Kenneth A · Willow, AKBuilt 1962 · S/N 28-822 N56580Young Robert L Trustee · Ashland, OHBuilt 1973 · S/N 287325662 N5658UTully James W · Clarksville, TNBuilt 1969 · S/N 28-26454 N56591Williams Anthony S · Miramar, FLBuilt 1973 · S/N 28-7325664 N56592Clw Aviation LLC · Springville, ALBuilt 1973 · S/N 28-7325665 N56596Gutowski Michael H · Westfield, MABuilt 1973 · S/N 28-7405021 N5659QKlempel Reuel David · Eltopia, WAS/N 3028 N5659RBeckham Kyle J · Wasilla, AKBuilt 1985 · S/N 8062C N5659WLeon James M · Frankfort, ILBuilt 1962 · S/N 28-826 N566Green Adam Ray · Fairbanks, AKBuilt 1979 · S/N 001 N56607Arsenault Mark E · Northampton, MABuilt 1973 · S/N 28-7405022 N5660SRussek Ron · Cleburne, TXFirst renewal noticeBuilt 1966 · S/N MB-101 N5660UBecker Timothy L · Vail, AZBuilt 1969 · S/N 28-26457 N5660WLopez Javier Garcia · San Jose, CABuilt 1962 · S/N 28-865 N5661Bryant Billy Joe · Seymour, TNBuilt 1971 · S/N 588S N56617Cherokee N56090 LLC · Jackson, GABuilt 1973 · S/N 28-7325671 N56619Rock Water Aviation LLC · Herriman, UTBuilt 1973 · S/N 28-7405023 N5661USkyventure LLC · Washington, INS/N 28-26458 N5662PSullivan Anthony J · Snohomish, WABuilt 1959 · S/N 24-734 N5662UBurgin John F · Austin, TXS/N 28-26459 N56637Hohenstein Douglas · Spokane, WABuilt 1973 · S/N 28-7325674 N5663QCullen Andrew W · Tennille, GAS/N 3030 N56651Boettcher Kurt · Julian, CABuilt 1973 · S/N 28-7405025

Back to AD 79-10-03 R2