OpenAirDocs.org
AD 58-19-01

Registered aircraft · 39

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
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:58-19-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:58-19-01')
  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.

N108QCastle Air Museum · Atwater, CAS/N 91188N109KMid Atlantic Air Museum · Reading, PABuilt 1945 · S/N 53638N145WBFew Tbms LLC · Rio Grande, NJBuilt 1945 · S/N 85460N28SFAvenger Educators LLC · Wilmington, DES/N 85983N293ETbm LLC · West Fargo, NDBuilt 1944 · S/N 53829N325GTBerry Darrel · Camden, TNS/N 69325N33BMHistoric Aircraft Preservation Group Inc · Orange, CAS/N 53119N3969ACenterline Holdings Inc · Camden, DEBuilt 1945 · S/N 53787N40402American Airpower Heritage Flying Museum · Dallas, TXBuilt 1945 · S/N 91426N4169AAvenger LLC · Beaverton, ORBuilt 1945 · S/N 5653N4170AJohnson Christopher E · Fort Valley, VAS/N 91453N4171ATbm Avenger LLC · Huntington, INBuilt 1945 · S/N 91521N420GPTri-State Warbird Museum · Batavia, OHBuilt 1944 · S/N 53420N436GMCartledge Charles J · Orrville, OHBuilt 1945 · S/N 91436N5260VCbs Aviation LLC · Jackson, MSBuilt 1945 · S/N 91726N5264VAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1945 · S/N 53353N53503American Airpower Heritage Flying Museum · Dallas, TXBuilt 1948 · S/N 53503N6447CLone Star Flight Museum · Houston, TXBuilt 1945 · S/N 53575N65VCFagen Fighters Restoration LLC · Granite Falls, MNS/N 85715N683GBuck Thomas DBA · Joliet, ILBuilt 1943 · S/N 53768N6VCGreatest Generation Naval Museum · Colorado Springs, COBuilt 1945 · S/N 53139N7030CTsi Holdco Inc · Virginia Beach, VAS/N 53454N704QZFagen Fighter Restoration LLC · Granite Falls, MNS/N 85597N7075CPond Warbirds LLC · Reno, NVBuilt 1945 · S/N 53785N7226CGlover William Scott · Mount Pleasant, TXS/N 85938N73642Db Aero · Wilmington, DES/N 69329N7835CPlanes Of Fame Air Museum · Chino, CAS/N 7154N81865Tbm Avenger Inc · Peru, ILBuilt 1945 · S/N 5632N8397HWar Eagles Air Museum · Santa Teresa, NMBuilt 1945 · S/N 69459N85650Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1945 · S/N 85650N86280Cavanaugh Air LLC · Addison, TXS/N 86280N88JZAcv Group LLC · Mckinleyville, CABuilt 1945 · S/N 85794N93818Ace Maker Aviation LLC · San Rafael, CABuilt 1945 · S/N 53818N9547ZSummers Sidney F · San Diego, CAS/N 85957N9548ZWeeks Kermit · Polk City, FLBuilt 1939 · S/N 91598N9564ZMissionair Inc · Danbury, CTS/N 91388N9584ZN9584z LLC · Latham, NYBuilt 1945 · S/N 85882N9586ZP O B Inc · Dover, DEBuilt 1945 · S/N 85886N9590ZCollings Foundation Inc · Stow, MABuilt 1944 · S/N 91733
Back to AD 58-19-01